-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Minor - P4
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
The current seek estimator passes to Newton-Raphson the sampleNDV satisfying the given bounds but the total sample size as the population count, including those not satisfying the given bounds, confusing the two populations.
The sketch of a fix improved plan quality on the plan stability tests and synthetic benchmarks.
Came up while I was working on SERVER-134637.
- blocks
-
SERVER-139193 Improve samplingCE for wildcard indices
-
- Backlog
-
- is related to
-
SERVER-134637 CE of wildcard/hashed/collated index scans
-
- Closed
-