Statistics are mainly used by the query optimizer to estimate no. of rows a query returns. In the first exercise of this Lab, we will explore different types of statistics. In the second exercise, we will look at how statistics works and a different component of statistics. And in the third exercise, we will explore update of statistics and different database level configuration related to updating statistics.
Exercise 1: Statistics Overview
Exercise 2: Statistics Internals
Exercise 3: Statistics Update