MongoDB Create Indexes

MongoDB Create Indexes

In MongoDB, the createIndexes operation is used to create multiple indexes on a collection in a single command. This method allows you to optimize query performance and ensure efficient data retrieval within MongoDB collections.

Syntax

db.collection.createIndexes(indexes)

The createIndexes method takes an array of index specification documents.

Example MongoDB Create Indexes

Let's look at an example of how to use the createIndexes method in the programGuru collection in MongoDB:

1. Create Multiple Indexes

db.programGuru.createIndexes([
    { key: { name: 1 }, name: "name_index" },
    { key: { age: -1 }, name: "age_index" },
    { key: { email: 1 }, name: "email_index", unique: true }
])

This command creates three indexes: an ascending index on the name field, a descending index on the age field, and a unique index on the email field in the programGuru collection.

Full Example

Let's go through a complete example that includes switching to a database, creating a collection, inserting documents, and creating multiple indexes.

Step 1: Switch to a Database

This step involves switching to a database named myDatabase.

use myDatabase

In this example, we switch to the myDatabase database.

MongoDB Create Indexes

Step 2: Create a Collection

This step involves creating a new collection named programGuru in the myDatabase database.

db.createCollection("programGuru")

Here, we create a collection named programGuru.

MongoDB Create Indexes

Step 3: Insert Documents into the Collection

This step involves inserting documents into the programGuru collection.

db.programGuru.insertMany([
    { name: "John Doe", age: 30, email: "john.doe@example.com" },
    { name: "Jane Smith", age: 25, email: "jane.smith@example.com" },
    { name: "Jim Brown", age: 35, email: "jim.brown@example.com" }
])

We insert multiple documents into the programGuru collection.

MongoDB Create Indexes

Step 4: Create Multiple Indexes in the Collection

This step involves using the createIndexes method to create multiple indexes in the programGuru collection.

db.programGuru.createIndexes([
    { key: { name: 1 }, name: "name_index" },
    { key: { age: -1 }, name: "age_index" },
    { key: { email: 1 }, name: "email_index", unique: true }
])

We create three indexes: an ascending index on the name field, a descending index on the age field, and a unique index on the email field.

MongoDB Create Indexes

Conclusion

The MongoDB createIndexes operation is crucial for optimizing query performance and ensuring efficient data retrieval. Understanding how to create multiple indexes in a single command allows you to enhance the performance and scalability of your MongoDB applications.