May 07 2024 04:08 PM
Hi Azure Cosmos Db team,
We need to use NOT IS_DEFINED to evaluate a property below
NOT IS_DEFINED(c.TestLocation['South Central US']
per the results analyzed NOT IS_DEFINED is not utilizing Index and is doing a full scan. There was an update from Cosmos Db Team that NOT IS_DEFINED can utilize index now. Below is the blog pertaining the same.
https://devblogs.microsoft.com/cosmosdb/april-query-improvements/
Can you please provide an alternative available if we cannot use NOT IS_DEFINED to evaluate the same property and to utilize index without a data model update?
With Regards,
Nitin Rahim
May 07 2024 04:49 PM
@mannu2050 can you help here? Thank you kindly!
May 07 2024 08:23 PM
May 08 2024 09:44 AM