EqLookupNode::providedSorts() method return a conservative empty ProvidedSortSet.
This may be inefficient and if used in translation, may introduce unnecessary sort stage, when underlying plan was already sorted.
The EqLookupNode may provide sort order identical or similar to child sort order, depending on "joinField".
If "joinField" is disjoint from the sort order, then EqLookupNode will retain it.
However, if "joinField" is of of the fields in the underlying sort order, then we can only keep the sort prefix up to, but without "joinField".
- related to
-
SERVER-69888 Complete TODO listed in SERVER-62815
- Closed