-
Type: Improvement
-
Resolution: Done
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: Querying
The current 'optimal' index heuristic does not take index uniqueness into account, but if a query expresses a single complete key of a unique index we know the number of scanned docs can be at most 1 on the index and should choose that index unless matches are impossible on another index.
- is related to
-
SERVER-10026 New query system
- Closed
- related to
-
SERVER-4670 query optimizer refactoring and performance enhancements for single document lookup, idhack
- Closed