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

Consider parameterizing the $lookup inner pipeline at the optimization phase, not execution phase

    • Query Optimization
    • 4

      The more fundamental issue that caused BF-28050 is that we repeatedly parse and optimize the $lookup inner pipeline for each input document, not parameterizing the inner pipeline.

      The classic $lookup would be used in foreseeable future given that the Nebari $lookup (hash lookup) does not support $lookup with inner pipeline and even though the Nebari $lookup supports $lookup with inner pipeline, it may take a while until we can fully switch to Nebari.

      Hope we could address this issue sooner or later.

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            yoonsoo.kim@mongodb.com Yoon Soo Kim
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated: