Discover ways to troubleshoot and optimize queries in Azure Cosmos DB using the Core (SQL) API. Program Manager Tim Sander demonstrates.

Content Index

  • 0:30 Request Units (database throughput capacity)
  • 3:30 Including necessary paths
  • 8:30 Optimizing ORDER BY queries
  • 11:30 Optimizing JOINs
  • 13:15 Avoiding cross-partition queries

Get started:

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 showcase correlated subqueries and examples of how they can make it easier to query arrays in Azure Cosmos DB.

              Related Links: