I have created an adaptive index on a bucket Binaries and 4 attributes as mentioned below in the query:
WHERE _type = “ChecklistMetadata”;
But somehow this index is not getting used while querying.
Previously, we had individual indexes for all the above attributes. For instance: CREATE INDEX
_id) where _type=“ChecklistMetadata”;
Currently, we are trying to club all the index using adaptive index syntax, but we are failing to do so.
Please let is know whats the issue with the adaptive index we are creating. And what changes is required to make that work.