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

Follow up pipeline golden tests with overridden Cost Model

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

      The new Cost Model introduces ABT nodes startup costs and makes IndexScan plans relatively more expansive then PhysicalScan on smaller collections. It laso makes index intersection plans with HashJoin and MergeJoin more expensive comparing to plain IndexScan plans which sometimes make IndexScan plan more preferable over index intersection plans.

      As a result, we use old Cost Model in the pipeline golden tests to guarantee that the generated plans are the same.

      This ticket is created to keep track of the override and consider possibility of changing the tests to use the new model at some moment.

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            alexander.ignatyev@mongodb.com Alexander Ignatyev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: