On 22 March 2018 at 09:42, Dean Rasheed wrote:
> Improve ANALYZE's strategy for finding MCVs.
> Thus it tends to produce
> fewer MCVs than the previous code for uniform distributions, and more
> for non-uniform distributions, reducing estimation errors in both
> cases. In addition, the algorith
Improve ANALYZE's strategy for finding MCVs.
Previously, a value was included in the MCV list if its frequency was
25% larger than the estimated average frequency of all nonnull values
in the table. For uniform distributions, that can lead to values
being included in the MCV list and significantl
