Details
-
Task
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
-
Query Optimization
-
Fully Compatible
-
QO 2023-01-09, QO 2023-01-23
Description
Currently, we estimate non-histogrammable types as the total count of values for that type (so any predicate matching an object will be estimated as the total count of objects). We can do better by instead estimating this as kDefaultSelectivity*numType (i.e. applying a heuristic estimate to the count for that type).