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

not cache meaningless plan, it will increased memory overhead and increase computing overhead.

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

       when the mode is PlanCachingMode::AlwaysCache or PlanCachingMode::SometimesCache, there is a special case.
       take Classic plan cache for example:
         If the winning index's advanced = 0 && works == 1 && isEOF == true, which means we didn't get any data to rank score, all candidates 
         score is same. the score of the calculation is meaningless.

      In this case, if we cache the plan, it will increased memory overhead. when the cached plan stage pick best plan, it will trigger replan. this will increase computing overhead.

        1. image-2023-06-15-14-51-29-750.png
          29 kB
          y yz
        2. image-2023-06-15-14-52-20-383.png
          53 kB
          y yz

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            1147952115@qq.com y yz
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated: