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

Re-enable caching of single solution plans

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 6.0.0-rc5, 6.1.0-rc0
    • 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

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: