-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
This is regarding the flag "kInternalCascadesOptimizerDisableScanDefault".
Currently we have 3 options: heuristic, sampling, and histograms. The sampling is currently ignored for small sizes while the histogram is not. The reasoning behind is that it may be too slow given the relative collection size.
The goal of this ticket is to:
- Add "auto" CE estimator mode which will select the best estimator (contingent on current efforts to implement estimation based on histograms)
- Allow forcing of estimation strategies (independent on the metadata).
- depends on
-
SERVER-68490 Integrate histogram estimation with the statistics module and the optimizer
- Closed