How to use composite indexes and correlated subqueries with Azure Cosmos DB
About this episode
Tim Sander joins Scott Hanselman to discuss composite indexes and correlated subqueries using the SQL API in Azure Cosmos DB. A Request Unit, or RU, is the measure of throughput in Azure Cosmos DB. Learn how to optimize queries with a composite index to decrease the RUs needed for a given query. They also showcases correlated subqueries and examples of how they can make it easier to query arrays in Azure Cosmos DB.[0:01:15] - Demo: composite indexes [0:04:20] - Demo: correlated subqueriesIndexing policies in Azure Cosmos DB - Composite IndexesSQL subquery examples for Azure Cosmos DBAzure Cosmos DB workshop labs (GitHub)Azure Cosmos DB overviewCreate a free account (Azure)
Get every episode summarized
Each time Azure Friday publishes, we email you a written briefing from the transcript — the topics, who appeared, and any specific claims, with the ad reads skipped.
Email me new episodesFree for 3 shows. No card needed.
Hosts & guests
No transcript yet
This episode has not been transcribed. Request it and it moves to the front of the queue.
More episodes
More from Azure Friday
Deploying Aspire Apps to Azure App Service for Linux
Azure Friday
Future-proof Postgres for better performance and scale
Azure Friday
Turning Coding Agents into an Azure Cosmos DB Expert with the Agent Kit
Azure Friday
Meet Azure HorizonDB, the new Postgres on Azure
Azure Friday