MongoDB

Indexes Commands

Indexes are crucial for MongoDB query performance. Learn to create, analyze, and manage indexes effectively.

6 commands

Pro Tips

Use .explain('executionStats') to verify indexes are being used.

In compound indexes, field order matters - put equality matches first.

Index builds can impact performance. Use { background: true } for large collections.

$ db.users.createIndex({ email: 1 })

Create ascending index on field.

$ db.users.createIndex({ email: 1 }, { unique: true })

Create unique constraint index.

$ db.users.createIndex({ lastName: 1, firstName: 1 })

Create index on multiple fields.

$ db.articles.createIndex({ content: "text" })

Create full-text search index.

$ db.users.getIndexes()

Show all indexes on collection.

$ db.users.dropIndex("email_1")

Remove an index by name.