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

Consider including the EOF bonus in the plan cache score

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.9.0
    • Component/s: None
    • Labels:
    • Backwards Compatibility:
      Fully Compatible
    • Sprint:
      Query 2021-01-25, Query Optimization 2021-02-22
    • Case:

      Description

      Currently, EOF bonuses are stripped from plan scores prior to being saved in the plan cache. This comment implies that the logic relates to plan eviction. This seems to no longer apply due to the replanning mechanism that was introduced in 3.0.

      This may result in getPlansByQuery() output where the first plan listed (the winning/cached plan) has a lower score than subsequent entries.

        Attachments

          Activity

            People

            Assignee:
            timour.katchaounov Timour Katchaounov
            Reporter:
            christopher.harris Christopher Harris
            Participants:
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: