[SERVER-81973] Implement generic logic to configure which phases and rewrites to run for input query Created: 09/Oct/23  Updated: 11/Dec/23  Resolved: 11/Dec/23

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

Type: Task Priority: Major - P3
Reporter: Henri Nikku Assignee: Alya Berciu
Resolution: Fixed Votes: 0
Labels: M9
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-80581 Microbenchmarks - investigate regress... Closed
is depended on by SERVER-83456 Skip Filter->Sargable rewrite for col... Closed
is depended on by SERVER-83839 Implement query-knob guarded logic to... Closed
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-10-16, QO 2023-11-27, QO 2023-12-11
Participants:

 Description   

Queries with a single comparison predicate are currently being converted to SargableNodes (and then back to FilterNodes). These queries do not benefit from this conversion, which adds overhead and leads to a noticeable increase in optimization latency. Once implemented, the configuration mechanism can be used to skip the FilterSubstitute rewrite for such queries.



 Comments   
Comment by Githook User [ 11/Dec/23 ]

Author:

{'name': 'Alya Berciu', 'email': 'alya.berciu@mongodb.com', 'username': 'alyacb'}

Message: SERVER-81973 Make phases and rewrites configurable

GitOrigin-RevId: b33cbef66601f55c900ab5acbc74791c593dc845
Branch: master
https://github.com/mongodb/mongo/commit/297738e97307807736c4396b6780511a72232e8f

Comment by Henri Nikku [ 12/Oct/23 ]

Draft PR: https://github.com/10gen/mongo/pull/16198/files

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