You can now use the Azure Cosmos DB indexing metrics, now generally available, to optimize query performance! The indexing metrics show indexes that the query engine used and index recommendations for improving query performance.
You can now use composite indexes in Azure Cosmos DB to optimize additional cases of the most common inefficient queries! Anytime you have a slow or high RU query, you should first consider whether the query can be optimized with a composite index.
This blog is the final part of a series of blogs where we’ll demystify commonly confused concepts for developers learning how to query data using Azure Cosmos DB. Today, we’ll walk through tips and tricks for querying arrays.
In this blog, we’ll cover how to add and remove indexes using the new indexing policy editor. We’ll also highlight the differences in best practices for indexing in Azure Cosmos DB’s API for MongoDB and native MongoDB.
Azure Synapse Link now supports querying Azure Cosmos DB data using Synapse SQL serverless. This capability, available in public preview, allows you to use familiar analytical T-SQL queries and build powerful near real-time BI dashboards on Azure Cosmos DB data.