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

Re-enable caching of single solution plans

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.0.0-rc5, 6.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • v6.0
    • QE 2022-04-04, QE 2022-03-21, QE 2022-04-18, QE 2022-05-02, QE 2022-05-16
    • 148

      The classic plan cache did not create a cache entry for queries that only have a single solution. (Improving this is tracked by SERVER-13341.) The SBE plan cache, on the other hand, will cache single solution plans. This allows us to skip the cost of recompiling the SBE plan, even if there is no need to skip multi-planning.

      The work for this improvement was originally implemented under SERVER-61083 but then subsequently disabled by SERVER-64314 since we observed some subtle correctness issues that were tricky to diagnose. The work for this ticket is to re-enable caching of single solution plans in the SBE plan cache. This will involve investigating and fixing the relevant build failures in addition to reverting the patch from SERVER-64314 that temporarily disabled single-solution SBE plan caching.

            Assignee:
            david.storch@mongodb.com David Storch
            Reporter:
            anton.korshunov@mongodb.com Anton Korshunov
            Votes:
            0 Vote for this issue
            Watchers:
            17 Start watching this issue

              Created:
              Updated:
              Resolved: