Episode

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

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 subqueries

Azure