I have a collection with almost 2.4 million docs (and growing strongly).
I have the following unique, compound index for the fields
When I run a simple
$or query where I check for both the
kit2 field I was expecting that it would use the index. But the explain feature tells me that there’s no index available for this query:
While Atlas is still fast (50 ms for the COLLSCAN), I want this query to use an index.
Why doesn’t it use the existing index?
What index do I need to add or how can I change my query to let it use the existing index?
Thanks in advance!