Indexing policies and query cost

DP-420 · Optimize an Azure Cosmos DB solution · Updated

How Azure Cosmos DB indexes items automatically, how to include or exclude paths, build composite and spatial indexes, and cut the RU charge of queries.

This lesson is part of full DP-420 access

The first 2 DP-420 lessons are free. Full access opens every lesson with its practice questions, and the exam-style DP-420 question bank.

In this lesson
  • Default policy
  • Tuning with paths
  • Index types
  • Composite indexes
  • Reducing query cost
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

DP-420 course outline

All 8 lessons · Course overview
  1. Modeling data - embed or referenceDesign and implement data models Free
  2. Choosing partition keysDesign and implement data distribution Free
  3. Consistency levels and global distributionDesign and implement data distribution Full access
  4. Change feed and Azure FunctionsIntegrate an Azure Cosmos DB solution Full access
  5. Stored procedures, triggers and UDFsIntegrate an Azure Cosmos DB solution Full access
  6. Indexing policies and query costOptimize an Azure Cosmos DB solution Full access
  7. Throughput, RU/s and 429 errorsOptimize an Azure Cosmos DB solution Full access
  8. Security, backup and monitoringMaintain an Azure Cosmos DB solution Full access