Create, View, and Drop Indexes
You can use the Atlas CLI or the Atlas UI to manage indexes on your collections.
Indexes support the efficient execution of queries in MongoDB and should be considered for fields which your application reads often. To learn more about creating effective indexes, see Indexing Strategies.
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
Tip
When you create indexes, keep the ratio of reads to writes on the target collection in mind. Indexes come with a performance cost, but are more than worth the cost for frequent queries on large data sets. Before you create an index, review the documented indexing strategies.
Note
You can build full-text search with Atlas Search. Atlas Search offers fine-grained text indexing. To learn more, see Review Atlas Search Index Syntax.
Drop an Index
To drop an index from a collection through the Atlas UI:
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.
Important
You cannot delete the _id index. To learn more, see
Unique Indexes.
Note
Atlas CLI Limitation
You can't drop a cluster's index using the Atlas CLI.