|
When skipping the Filter->Sargable transformation, the optimizer doesn't generate partial schema requirements, and consequently doesn't callĀ
PartialSchemaReqLowerTransport which in turn would call consolidateEqDisjunctions(). As a result not all disjunctions are consolidated into a single eqMember. This task should:
The potential performance benefit of this rewrite should come from:
- potentially removing duplicate disjunctions
- reducing the size of the SBE plan, and using a single traverseF with a single isMember instead of multiple traverseF for each equality.
This rewrite could be done as part of a more general simplification.
|