Manage Indexes in Data Explorer

In MongoDB Cloud Manager, go to the Deployment page for your project.

1. If it is not already displayed, select the organization that contains your desired project from the Organizations menu in the navigation bar.

2. If it's not already displayed, select your desired project from the Projects menu in the navigation bar.

3. If the Deployment page is not already displayed, click Deployment in the sidebar.

   The Deployment page displays.

Go to the Data tab

1. Select the desired MongoDB deployment.

2. Select the Data tab.

Select the database for the collection.

The main panel and Namespaces on the left side list the collections in the database.

click to enlarge

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.

click to enlarge

Go to the Indexes tab.

1. Click the collection you wish to index.

2. 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:

{ <field1>: <index type>, ... }

{ category: 1, score: -1 }

For more information on indexes, see Indexes.

(Optional) Specify the index options.

{ <option1>: <value1>, ... }

{ unique: true, name: "myUniqueIndex" }

(Optional) Set the Collation options.

Use collation to specify language-specific rules for string comparison, such as rules for lettercase and accent marks. The collation document contains a locale field which indicates the ICU Locale code, and may contain other fields to define collation behavior.

{ "locale": "fr" }

To review the list of locales that MongoDB collation supports, see the list of languages and locales. To learn more about collation options, including which are enabled by default for each locale, see Collation in the MongoDB manual.

(Optional) Build indexes with rolling builds.

Building indexes in a rolling fashion reduces the performance impact of building indexes on replica sets and sharded clusters. To maintain cluster availability, Cloud Manager removes one node from the cluster at a time starting with a secondary.

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.

Cloud Manager automatically cancels rolling index builds that don't succeed on all nodes. When a rolling index build completes on some nodes, but fails on others, Cloud Manager cancels the build and removes the index from any nodes that it was successfully built on.

In the event of a rolling index build cancellation, Cloud Manager generates an activity feed event and sends a notification email to the project owner with the following information:

• Name of the cluster on which the rolling index build failed

• Namespace on which the rolling index build failed

• Project that contains the cluster and namespace

• Organization that contains the project

• Link to the activity feed event

To learn more about rebuilding indexes, see Build Indexes on Replica Sets.

Click Create.

Confirm 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.

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.