SQL Server Statistics Internals

Home/Administration, SQL Server/SQL Server Statistics Internals

SQL Server Statistics Internals

$4.00

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

Description

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

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Content missing