Search

Home > GroupBy – Free SQL Server Training > Getting Better Query Plans by Improving SQL’s Estimates by Brent Ozar
Podcast: GroupBy – Free SQL Server Training
Episode:

Getting Better Query Plans by Improving SQL’s Estimates by Brent Ozar
Category: Technology
Duration: 00:50:36
Publish Date: 2018-07-03 05:00:00
Description:

You've been writing T-SQL queries for a few years now, and when you have performance issues, you've been updating stats and using OPTION (RECOMPILE). It's served you well, but every now and then, you hit a problem you can't solve. Your data's been growing larger, your queries are taking longer to run, and you're starting to wonder: how can I start getting better query plans?

The secret is often comparing the query plan's estimated number of rows to actual number of rows. If they're different, it's up to you - not the SQL Server engine - to figure out why the guesses are wrong. To improve 'em, you can change your T-SQL, the way the data's structured and stored, or how SQL Server thinks about the data.

This session won't fix every query - but it'll give you a starting point to understand what you're looking at, and where to go next as you learn about the Cardinality Estimator.
Total Play: 0