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.
- Indexing policies in Azure Cosmos DB – Composite Indexes
- SQL subquery examples for Azure Cosmos DB
- Azure Cosmos DB workshop labs (GitHub)
- Azure Cosmos DB overview
- Create a free account (Azure)
How to use composite indexes and correlated subqueries with Azure Cosmos DB | Azure Friday
Source: MSDN Channel 9