How to use composite indexes and correlated subqueries with Azure Cosmos DB
Azure Friday · Scott Hanselman, Rob Caron
December 6, 2019
Audio is streamed directly from the publisher (dts.podtrac.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
<p>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)</p>