How do you verify a MongoDB index is being used?
Run .explain('executionStats'). Look at winningPlan.stage (IXSCAN is good, COLLSCAN is bad) and executionStats.totalDocsExamined (should be small, close to the number of documents returned).
Verify This Answer
Cross-check this information using these trusted sources:
More FAQs in MongoDB Indexes Interview Questions and Answers
An index on two or more fields. MongoDB can use it for queries on any prefix of the indexed fields. Order matters: equality first, then sort, then range (ESR rule).
A compound index on (A, B, C) can be used for A, A+B, or A+B+C. It cannot be used for B, C, or B+C. If you query on B+C, you need a separate index on (B, C).
Because MongoDB has to update each index on every insert, update, and delete. Indexes are a tradeoff: faster reads, slower writes. Index only the queries you actually run; do not index every field.
Still have questions?
Browse all our FAQs or reach out to our support team