Details
-
Improvement
-
Resolution: Unresolved
-
Major - P3
-
None
-
None
-
None
-
None
-
Query Optimization
Description
Avoid computing candidate indexes and scan params for Sargable nodes which do not sit directly above a Scan node.
Those computations are redundant. Such sargable nodes will either need to be merged together, or will be expanded back to filter/eval nodes in the exploration phase.
Attachments
Issue Links
- is related to
-
SERVER-76761 [CQF] Investigate lowerEqPrefixes being called for Sargable [Seek]
-
- Closed
-