How are statistics used in a query optimizer?

This measure represents units of work or resource used. The query optimizer uses disk I/O, CPU usage, and memory usage as units of work. As shown in the following graphic, if statistics are available, then the estimator uses them to compute the measures. The statistics improve the degree of accuracy of the measures.
For More Information Please Refer:


You May Also Like to Read: