How to connect virtual networks across Azure regions with Azure Global VNet peering
Build with an Azure free account. Get USD200 credit for 30 days and 12 months of free services.
Start free todayHow to use composite indexes and correlated subqueries with Azure Cosmos DB
Play How to use composite indexes and correlated subqueries with Azure Cosmos DB
Description
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
- Indexing policies in Azure Cosmos DB - Composite Indexes
- SQL subquery examples for Azure Cosmos DB
- Azure Cosmos DB workshop labs (GitHub)
- Azure Cosmos DB overview
- Create a free account (Azure)
Download
The Discussion
-
omerzubair This is perfect to make non-cloud developers understand the value of composite index.
In cloud world it is directly linked to RUs = budgets = cost = Real $$$!
Thanks @Scott & @Rob. i will share this with my teams mates. -
pandyamehul fantastic demo and great work! -
Stef I think Scott tried to avoid the confusion of the viewer on the string with commas, but that got lost :).
More episodes in this series
How to share data in place from Azure Data Explorer
Related episodes
Azure Cosmos DB Free Tier and Autopilot
How to do Bulk and Transactional Batch operations with the Azure Cosmos DB .NET SDK
How to use Jupyter Notebook and Apache Spark in Azure Cosmos DB
Azure Cosmos DB update for August 2019
Debugging and optimizing Azure Cosmos DB performance
Serverless geo-distributed applications with Azure Cosmos DB
Azure Cosmos DB update: SDKs, CORS, multi-region strong consistency, and more
An intro to Azure Cosmos DB .NET SDK 3.0
An intro to Azure Cosmos DB JavaScript SDK 2.0
Global real-time multi-user apps with Azure Cosmos DB
