EPISODE · Dec 6, 2019
How to use composite indexes and correlated subqueries with Azure Cosmos DB
from Azure Friday · host Scott Hanselman, Rob Caron
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)
Embed this episode
NOW PLAYING
How to use composite indexes and correlated subqueries with Azure Cosmos DB
No transcript for this episode yet
Similar Episodes
No similar episodes found.
Similar Podcasts
No similar podcasts found.