-
Type:
Sub-task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
Fully Compatible
-
200
-
None
-
3
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Sometimes, part of the predicate can be pushed down to the IXSCAN stage filter and minimise or even avoid fetching.
Predicate: AND [a=1, b=1]
Sort: c_1
Index: (c_1_a_1)
Resulting query
FETCH filter: AND [a=1, b=1] IXSCAN: pattern: (c_1_a_1)
Optimal query:
FETCH filter: b=1 IXSCAN: filter: a=1 pattern: (c_1_a_1)
- causes
-
SERVER-107527 Incorrect predicates push down to IndexScan
-
- Closed
-
- related to
-
SERVER-12769 Queries that scan an entire index to provide a sort should be covered when possible
-
- In Progress
-