Refactor SBE stage builder to reuse the conversion of index scans in index-based $lookup

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Fixed
    • Priority: Major - P3
    • 9.0.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • QE 2026-05-11, QE 2026-04-27, QE 2026-04-13, QE 2026-05-25, QE 2026-06-08
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Currently $lookup in SBE creates a dedicate index scanning logic starting from the choice of which index to use. It would be better to reuse the standard handling of index scans (including multiple non-overlapping index boundaries, covering indexes, post-index filtering, etc...) by invoking 
      SlotBasedStageBuilder::build() on the FETCH+IXSCAN QuerySolutionNode objects introduced by SERVER-118014

            Assignee:
            Alberto Massari
            Reporter:
            Alberto Massari
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: