Indexing & Performance

Module Contents

1. Index Fundamentals & The B-Tree

Understand why linear scans are slow and how B-Trees provide O(log N) search performance. Learn about Single Field, Compound, Multikey, and TTL indexes.

2. The ESR Rule & Query Targeting

Master the art of index design. Learn why Equality, Sort, Range is the optimal field order and how to achieve zero-I/O Covered Queries.

3. Explain Plans & Profiling

Stop guessing. Use .explain("executionStats") to diagnose bottlenecks, identify COLLSCANs, and optimize your query performance.

Review & Cheat Sheet

Test your knowledge with flashcards, review key takeaways, and access a quick-reference cheat sheet for index commands.

Module Chapters