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)
Fler avsnitt av Azure Friday
Visa alla avsnitt av Azure FridayAzure Friday med Scott Hanselman finns tillgänglig på flera plattformar. Informationen på denna sida kommer från offentliga podd-flöden.
