Enhanced SQL API query functionality in Azure Cosmos DB is now available
Posted on 15 May 2019
Now generally available, Azure Cosmos DB SQL API provides support for Distinct, Skip and Take, Correlated Subquery and Composite Indexes. Composite indexes let you create multi OrderBy queries. You will be able to continue to query using SQL as a JSON query language and will now have available to you an even richer set of features. Azure Cosmos DB also now has better performance of aggregates in queries. In most cases, aggregate’s RU consumption will decrease significantly.