Skill

documentdb-query-optimization

Name: documentdb-query-optimization
Author: Azure (Microsoft)

optimize Azure DocumentDB queries and pipelines

Published by Azure (Microsoft) Updated Jul 15

Covers Performance Azure Database Debugging

Description

Query and aggregation-pipeline optimization rules for Azure DocumentDB — using `explain("executionStats")` to verify index usage and avoid `COLLSCAN`. Use when reviewing a specific query, diagnosing a slow query, or validating that an index is actually being used. For full index-design workflow, see the `documentdb-query-optimizer` skill.

SKILL.md

Query & Aggregation Optimization — Azure DocumentDB

Best-practice rules for writing queries that can actually use indexes. For the full diagnostic workflow (explain output interpretation, ESR compound index design, covered queries, anti-patterns), see the documentdb-query-optimizer skill.

Rules

query-explain-plan — Use explain("executionStats") to verify index usage; watch keysExamined / docsExamined vs nReturned; avoid COLLSCAN.

More from Azure (Microsoft)

View publisher

SkillTagsUpdated