Guy Glantser
madeiradata.com/blog
Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS group and also the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years.
SQLBits 2023
The Most Important Performance Factor in SQL Server and Azure SQL
If you care about your database performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.
The most important factor in SQL Server and Azure SQL that affects query performance is statistics. When you execute a query, the optimizer needs to come up with the best possible execution plan for it, and it needs good and accurate statistics for that. Without them, the optimizer is blind, and your query performance will suffer.
In this session, we will get to know statistics, as well as the cardinality estimator – the component that is responsible for estimating row counts based on statistics. We will cover all types of statistics, such as column vs. index statistics, single-column vs. multi-column, filtered statistics, incremental statistics, and more. We will look at scan vs. seek operations, and we will examine how execution plans are made.
If you care about your database performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.
In this session, we will get to know statistics, as well as the cardinality estimator – the component that is responsible for estimating row counts based on statistics. We will cover all types of statistics, such as column vs. index statistics, single-column vs. multi-column, filtered statistics, incremental statistics, and more. We will look at scan vs. seek operations, and we will examine how execution plans are made.
If you care about your database performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.