Details
-
Improvement
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
Query Optimization
-
Fully Compatible
-
QO 2023-01-09, QO 2023-01-23
Description
When implementing SargableNode s, we can consider creating an expression which uses PathCompare [EqMember], rather than a composition of many PathCompare s.
A good place for implementation could be within the lowerPartialSchemaRequirement function.
This ticket is inspired by the approach here, which created a FilterNode with a call to isMember during translation of a $in.