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

[SBE] Produce EOF plan for pushed down $lookup when outer collection does not exist

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 8.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • Fully Compatible
    • v8.0
    • 200

      At the time of writing, we can get an elaborate plan for $lookup in SBE when the outer collection does not exist (but the inner one does). This ticket tracks the work to instead, produce EOF plans. 

      Note that if we do this, we should ensure that we don't wind up create a plan cache entry for the EOF plan (in case the outer collection does get created)

            Assignee:
            milena.ivanova@mongodb.com Milena Ivanova
            Reporter:
            mihai.andrei@mongodb.com Mihai Andrei
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: