SQL Server Statistics Internals

Home/Administration, SQL Server/SQL Server Statistics Internals

SQL Server Statistics Internals

$15.00 $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

Categories: ,

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

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Reviews

There are no reviews yet.

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