MongoDB Indexes, Explain Plans, and Performance

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

# Index one frequently filtered field.

db.orders.createIndex({ status: 1, created_at: -1 })

# Index fields used together in filters or sorts.

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

# Prevent duplicate values at write time.

db.articles.createIndex({ title: "text", body: "text" })

# Enable text search over string content.

db.users.getIndexes()

# Inspect existing indexes.

db.orders.find({ status: "paid" }).sort({ created_at: -1 }).explain("executionStats")

# Show the execution plan for a `find()` query.

db.orders.find({ status: "paid" }).hint({ status: 1, created_at: -1 })

# Test how a query behaves with a chosen index.

db.orders.hideIndex({ status: 1, created_at: -1 })

# Temporarily hide an index from the planner.

db.runCommand({ collStats: "orders" })

# View storage and index metrics for a collection.

db.orders.dropIndex({ status: 1, created_at: -1 })

# Remove an unneeded index.