Learn powerful statistics techniques to optimize query performance in this comprehensive conference talk from PASS Data Community Summit. Explore how to leverage filtered statistics for large tables with skewed data, utilize computed column statistics, adjust sample sizes, address stale statistics on ascending keys, and create manual statistics for correlated columns. Gain practical insights to significantly improve query execution plans and overall database performance. Discover when automatic statistics fall short and how to implement advanced strategies to provide the optimizer with better information for faster query processing.
Overview
Syllabus
Introduction
Agenda
The Optimizer
Statistics Overview
Reading Statistics
Correlation Columns
Covering Columns
Insufficient Granularity
Insufficient Column Statistics
Automatic Statistics Example
Summary
Taught by
PASS Data Community Summit
