-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
ALL
-
-
None
-
None
-
None
-
None
-
None
-
None
-
None
The current logic reads:
if (totalUniqueKeys == totalMatchingKeys) {
...
return estimatedIndexKeys;
}
ie. if all the matching keys in the sample are unique, we avoid Newton-Raphson, instead returning the estimated total number of index keys.
Instead we should return the estimated number of matching index keys.
Noticed while working on SERVER-134637.
- is caused by
-
SERVER-122379 Extend countNDV method to support multikey, filtered cases
-
- Closed
-
- is related to
-
SERVER-134637 CE of wildcard/hashed/collated index scans
-
- Closed
-