If you want to understand how the optimizer uses statistics when creating a query plan, and why they're so important, then join me for this session. We’ll define what statistics are, examine how the optimizer uses them, and review how to find cardinality estimate information in a plan. We’ll also cover the various ways statistics can be updated, and explore what happens to plans when those updates occur, so you can understand why maintaining statistics is essential for performance.

Understanding Statistics in SQL Server - SQL Server Virtual Conference 2021
Feb 01 2021

CSharp TV

This session is about Understanding Statistics in SQL Server by Erin Stellato in SQL Server Virtual Conference.