-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Supplement CardinalityEstimator::clampZeroEstimate with a more intelligent heuristic, for equality predicates in particular, since these can be effectively estimated from NDV and we can estimate NDV from the sample. Run a Chao1 estimator for distinct value estimation on the sample (or choose an alternative NDV estimator). Then calculate the equality predicate's CE asĀ 1/NDV.
- is related to
-
SERVER-139493 CBR limit propagation floors child limit shares, costing OR/AND subtrees as free under small limits
-
- Closed
-
-
SERVER-139211 Join cost model picks COLLSCAN + hash join over index nested loop join for in-memory data once cardinality estimates are accurate
-
- Closed
-