Cached plans from inner $lookup single solution queries should be pinned

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Single solution queries should always pin their plan cache entry, so that they are not subject to replanning. It doesn't make sense to potentially replan these queries because we will never get a different result.

      For classic, the only single solution plans we cache are the inner $lookup queries. For SBE, we create cache entries for a broader set of single solution queries. This ticket can consolidate logic between SBE and classic for caching single solution queries.

      This should be done before SBE is enabled for the inner side of $lookup.

              Assignee:
              Jess Balint
              Reporter:
              Matt Boros
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated: