[SERVER-78090] [CQF] Avoid computing candidate indexes and scan params in some cases Created: 14/Jun/23  Updated: 27/Jun/23

Status: Backlog
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Svilen Mihaylov (Inactive) Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to SERVER-76761 [CQF] Investigate lowerEqPrefixes bei... Closed
Assigned Teams:
Query Optimization
Participants:

 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.


Generated at Thu Feb 08 06:37:26 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.