[SERVER-81588] [CQF] Fall back to heuristic for sampling estimation of filters Created: 29/Sep/23  Updated: 03/Nov/23  Resolved: 03/Nov/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.2.0-rc0

Type: New Feature Priority: Major - P3
Reporter: Svilen Mihaylov (Inactive) Assignee: Chi-I Huang
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-80732 [CQF] Improve SamplingPlanExtractor t... Closed
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-11-13
Participants:

 Description   
  • By default do not perform round-trip optimization for Filters (but retain sargable node implementation).
  • Introduce a flag which controls this behavior. When flag is enabled for debugging continue to optimize filters via round-tripping.


 Comments   
Comment by Githook User [ 03/Nov/23 ]

Author:

{'name': 'Chi-I Huang', 'email': 'chii.huang@mongodb.com', 'username': 'chiihuang'}

Message: SERVER-81588 Fall back to heuristic for sampling estimation of filters

Always falls back on FilterNode, given that any FilterNode with fields indexed is supposed to be converted to a SargableNode during the substitution phase. Adds a query knob to control this behavior.
Branch: master
https://github.com/mongodb/mongo/commit/f18dc3b6b2a94407d4074b0c0c1d74dd07d7b80d

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