Indexing Design Fundamentals / Conclusion

Indexing Design Fundamentals

You learned how to:

Learning Objectives

Apply Indexing Best Strategies: Apply best practices including identifying the most frequent queries, creating the minimal number of indexes needed to support those frequent queries and understanding how to build efficient compound indexes.

Optimize Indexes for Performance: Be able to apply strategies such as ESR (equality, sort, range) when appropriate and know how to create indexes for a specific strategy.

Measure Index Performance: Use and interpret the outputs of the tooling such as explain() with your queries to determine if queries are using indexes.

Earn Your Badge

To earn your badge, complete the skill check following this page. Once you receive a passing score on the skill check, you'll receive an official Credly badge via the email you provided.

Resources

Use the following resources to learn more about MongoDB’s document model:

YouTube - Solving the Mystery of Index Use - Asya Kamsky
MongoDB Documentation: Indexes
MongoDB Documentation: Index Types
MongoDB Documentation: Index Properties
MongoDB Documentation: Manage Indexes
MongoDB Documentation: ESR Guideline
MongoDB Documentation: Create Indexes
MongoDB Documentation: explain()
MongoDB Documentation: Partial Indexes