Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Query Optimization Statistics - Driving Force Behind Performance

PASS Data Community Summit via YouTube

Start learning Write review
Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More → Noble Desktop Ad

Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This session explains how SQL Server’s query optimizer uses statistics and how to maintain them. It examines performance issues caused by ascending keys, skewed distributions, and inaccurate summary information, with examples and a stored procedure for finding ascending keys.

Syllabus

Intro
Agenda
What is the Optimizer
Complexity of the Optimizer
What are Statistics
Spstats
Show Statistics
Read Statistics
Maintain Statistics
Getting rid of Statistics
Auto Update Statistics
Persistent Sample Percent
Bad Samples
Default Sample Size
Step Column
Identity Column
Modified Date Column

Taught by

PASS Data Community Summit

Reviews

Start your review of Query Optimization Statistics - Driving Force Behind Performance

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.