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.
- is depended on by
-
SERVER-80581 Microbenchmarks - investigate regression in single top-level field query benchmark
- Closed
-
SERVER-83456 Skip Filter->Sargable rewrite for collscan plans
- Closed
-
SERVER-83839 Implement query-knob guarded logic to skip Sargable rewrites
- Closed