Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-62815

ProvidedSortSet in EqLookupNode is not optimal.

    • Type: Icon: Task Task
    • Resolution: Won't Do
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Execution

      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".
       

            Assignee:
            backlog-query-execution [DO NOT USE] Backlog - Query Execution
            Reporter:
            anna.wawrzyniak@mongodb.com Anna Wawrzyniak
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: