-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: 7.0.0, 6.0.7
-
Component/s: None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
When a query contains multiple predicates on the same field where some are sparse index compatible and others are not, the query planner performs a issues a collection scan plan instead of an index scan plan on the sparse index for the compatible predicates and applying incompatible predicates as filters.
This is caused by incorrect overriding of the sparse index compatibility info in QueryPlannerIXSelect::getFields The fix is never override supportSparse = true by supportSparse = False.
- is caused by
-
SERVER-74344 Ban use of sparse indexes on internal comparison expression unless explicitly hinted
-
- Closed
-