Getting Better Query Plans by Improving SQL's Estimates by Brent Ozar

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.

You can listen to Getting Better Query Plans by Improving SQL's Estimates by Brent Ozar online on Radio and Podcast. Open the player on this page to stream the available audio.

Getting Better Query Plans by Improving SQL's Estimates by Brent Ozar is an episode from GroupBy – Free SQL Server Training by Brent Ozar.

This episode is 50:36 long.

This episode was published on Jul 3, 2018.

Yes. Use the heart button on the episode page to add it to your favorite episodes list.

Yes. This page shows related episodes from GroupBy – Free SQL Server Training when more episodes are available from the podcast feed.