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.

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • Query Optimization

    Description

       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.

      Attachments

        Activity

          People

            backlog-query-optimization Backlog - Query Optimization
            1147952115@qq.com y yz
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated: