Optimize query performance using indexes in Azure DocumentDB
Intermediate
Developer
Azure Cosmos DB
Optimize query performance in Azure DocumentDB by building effective indexing strategies. Create single-field, compound, multi-key, and specialized indexes. To maintain performance at scale, analyze query execution with the explain() command and monitor index health.
Learning objectives
After completing this module, you'll be able to:
- Explain how indexes work internally and how they affect read and write performance.
- Create single-field, compound, multi-key, and specialized indexes based on query patterns.
- Use the explain() command to analyze query execution and identify performance bottlenecks.
- Monitor and optimize indexes for production workloads.
Prerequisites
- Familiarity with database concepts such as queries, indexes, and data models.
- Basic understanding of MongoDB or document-oriented databases.
- Experience with insert, query, update, and delete operations in Azure DocumentDB or MongoDB.
- An Azure subscription.
- An Azure DocumentDB cluster.