In this session you will understand how statistics are used by Query Optimizer to create an optimal execution plan. Learn how to read an histogram and how to optimize the accuracy of the estimation. Understand how to fix some problems like statistical correlations, missing statistics, gap in statistics, wrong estimations. Also you will understand: density, fooling statistics, auto update statistics, filtered statistics and date correlation optimization.
Are the “Estimated number of Rows“ estimating too much? Understand here how it was estimated and give a new meaning to the word “estimated”.

(no tags)