-
Type:
Task
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Fully Compatible
-
135
-
None
-
3
-
None
-
None
-
None
-
None
-
None
-
None
-
None
SERVER-82570 changed the query planner to remove some InternalExpr predicates in residual filters, and changed the SBE stage builders to unconditionally compile them (rather than to an always true predicate).
It turns out there are some common cases where InternalExpr expressions remain in the tree and get compiled, slowing down some filtering operations. We should make the rewrite more aggressive, to remove the imprecise predicates in more situations.
- related to
-
SERVER-107066 $expr equality predicate on a constant projected column defeats match pushdown optimization
-
- Closed
-