Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and play a part in execution plans. The cardinality estimator relies heavily on statistics to get the answer to selectivity (the ratio of distinct values to the total number of values) questions and calculate a cost estimate.
source https://www.c-sharpcorner.com/article/importance-of-statistics/
No comments:
Post a Comment