-
Type: Task
-
Resolution: Unresolved
-
Priority: 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.