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

Consistent automatic CE heuristic, strict CE modes and multi-planning

    • Type: Icon: Task Task
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • QO 2024-12-23, QO 2025-01-06, QO 2025-01-20

      Design and implement a automatic CE heuristic that is consistent with the strict CE modes (histogram and sampling CE).

      The design should fallback to heuristic CE only in reasonable cases unlike the current approach where each estimation failure falls back to heuristic CE.

      As a result some estimation errors will be covered by heuristic CE, but some other errors will result in the plan being multi-planned.

      This ticket may consider adding an extra query knob to control the degree of CE adherence to the prescribed mode, or modify the current CE knob.

            Assignee:
            timour.katchaounov@mongodb.com Timour Katchaounov
            Reporter:
            ben.shteinfeld@mongodb.com Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: