How to use composite indexes and correlated subqueries with Azure Cosmos DB | Azure Friday

Bit Ninja


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 showcase correlated subqueries and examples of how they can make it easier to query arrays in Azure Cosmos DB.

1:15 – Demo: composite indexes
4:20 – Demo: correlated subqueries

Indexing policies in Azure Cosmos DB – Composite Indexes
https://aka.ms/azfr/598/01

SQL subquery examples for Azure Cosmos DB
https://aka.ms/azfr/598/02

Azure Cosmos DB workshop labs (GitHub)
https://aka.ms/azfr/598/03

Azure Cosmos DB overview
https://aka.ms/azfr/598/04

Create a free account (Azure)
https://aka.ms/azfr/598/free

#microsoft #microsoftazure #azurecosmosdb


Duration: 00:10:26
Publisher: Microsoft Azure
You can watch this video also at the source.