Cheat Sheet logoCheat Sheet Today
MongoDB Indexes, Explain Plans, and Performance/Create a compound index

Index fields used together in filters or sorts.

Back to sheetBrowse commands
Sign in to save
Section: Create indexes

Create a compound index

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

Compound indexes are useful when queries filter and sort on a predictable pattern.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Create indexes
Create a single-field index
Index one frequently filtered field.
OpenIn sheetjavascriptsame section
Enforce uniqueness with an index
Prevent duplicate values at write time.
OpenIn sheetjavascriptsame section
Create a text index
Enable text search over string content.
OpenIn sheetjavascriptsame section
List indexes on a collection
Inspect existing indexes.
OpenIn sheetjavascriptsame section
Explain a query
Show the execution plan for a `find()` query.
OpenIn sheetjavascript1 tag match
Force a specific index with hint
Test how a query behaves with a chosen index.
OpenIn sheetjavascript1 tag match