- Create or Import a MongoDB Deployment >
- Data Explorer >
- Manage Indexes in Data Explorer
Manage Indexes in Data Explorer¶
On this page
You can use the Data Explorer to manage indexes on your collections.
To access the Data Explorer:
- Click Deployment in the left navigation.
- Select the desired MongoDB deployment.
- Select the Data Explorer tab.
Required Roles¶
To create or drop indexes, you must have access provided by at least one of the following roles:
View Indexes¶
From the Collections tab, you can view index information for a collection. To view index information for a collection:
Select the database for the collection.¶
The main panel and Namespaces on the left side list the collections in the database.
Select the collection on the left-hand side or in the main panel.¶
The main panel displays the Find, Indexes, and Aggregation views.
Select the Indexes view.¶
The indexes table lists the indexes and associated index information for the collection. Index information includes the index definition, the size, and the usage frequency.
Create an Index¶
To create an index for a collection through the Data Explorer:
Go to the Indexes tab.¶
- Click the collection you wish to index.
- Click the Indexes tab under the collection name.
Click + Create Index.¶
In the Create Index modal, enter the index key specification document in the Fields box:
Example
To create a compound index on the fields category
(ascending order) and score
(descending order), specify the
index specification document:
For more information on indexes, see Indexes.
(Optional) Specify the index options.¶
Example
To set the unique
option and the name
for the new index,
enter this document:
(Optional) Set the Collation options.¶
Locale is the ICU Locale code for local languages. To review the list of locales MongoDB collation supports, see the list of languages and locales.
- To learn more about the specific collation options, see Collation in the MongoDB manual.
- To learn which collation options are enabled by default for each locale, see Collation Locales and Default Values in the MongoDB Manual.
(Optional) Build indexes with rolling builds.¶
Select Build index via rolling process.
Important
Do not set the background construction option if you select this option. Background construction negates the performance benefit gained by building an index with a rolling build.
Building indexes with rolling builds reduces the performance impact of building indexes on replica sets and sharded clusters. Ops Manager maintains the availability of the cluster by taking one node out of the cluster at a time, starting with a secondary, building its index, and adding it back to the cluster.
After you build an index in a rolling fashion, if your MongoDB
database runs with an
FCV
less than 4.2
,
resync the head database to ensure
that the head database takes the new index into account.
To learn more about building indexes with rolling builds, see Build Indexes on Replica Sets.
Click Create.¶
To learn how to create indexes, see the MongoDB Manual.
Confirm or reject your index.¶
The Confirm Operation modal appears.
- If your index creation looks correct, click Confirm. This closes the modal and create the index.
- If your index creation looks incorrect, click Cancel. This closes the modal without creating the index.
Drop an Index¶
To drop an index from a collection through the Data Explorer:
Go to the Indexes tab.¶
Select the collection whose index you wish to drop, and go to the Indexes tab.
Click the Drop Index button for the index to drop.¶
Confirm action.¶
Confirm by typing the name of the index, and click Drop.
Note
You cannot delete the _id
index.