-
Type: Improvement
-
Resolution: Duplicate
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
None
For non $or queries, the query optimizer attempts to speculatively evaluate a query using multiple indexes in parallel, until 101 matches are found with a single index.
For $or queries, each $or clause can potentially speculatively evaluate multiple indexes. However, after 101 total matches are found speculative evaluation is stopped and an index is chosen arbitrarily for each $or clause.
This ticket represents allowing speculative index evaluation in $or clauses even after the first 101 matches are found.
- duplicates
-
SERVER-13184 2.6 should explore same number of one index solns as 2.4
- Closed