This blog is part two of a series of three blogs where we’ll demystify commonly confused concepts for developers learning how to query in the SQL (core) API in Azure Cosmos DB. We’ll look at the difference between null and undefined values.
With our latest service update, you can now create wildcard indexes in accounts that use Azure Cosmos DB’s API for MongoDB. Wildcard indexes are a popular feature in MongoDB 4.2 that allow you to index many properties without enumerating each one.
Azure Cosmos DB now supports case-insensitive Contains, StartsWith, EndsWith, and StringEquals. Additionally, both Contains and EndsWith have had significant performance improvements. You can now store string data in Azure Cosmos DB without having to worry about matching the case in the query.
We are constantly adding new query and indexing features to Azure Cosmos DB. This blog outlines a few recent query and indexing improvements for aggregates, inequality filters, and dates and time system functions. This blog covers updates during the first four months of 2020.