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

10:25
 
Share
 

Manage episode 247646634 series 46730
By Azure Friday (HD) - Channel 9. Discovered by Player FM and our community — copyright is owned by the publisher, not Player FM, and audio is streamed directly from their servers. Hit the Subscribe button to track updates in Player FM, or paste the feed URL into other podcast apps.

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

431 episodes