-
Type: Improvement
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Fully Compatible
-
QO 2022-11-14
Investigate what is the best cardinality estimate of the minimum value of a given data type, e.g. empty string. When the value falls inside of a bucket we can estimate the equality as follows:
1) use the equality frequency for the inner bucket values (rangeFreq / NDV)
2) use kMinCard = 0.01 (if the value actually exists in the data, this will lead to underestimation).