Dear SQL DBA cover image

Why is My Query Faster on the Second Run?

Dear SQL DBA

00:00

How Long Does It Take to Compile a Plan?

Sequel server is designed to try to get you a good plan, but it wants to compile that plan for you fast. The developers of sequelsover don't want you to be in a situation where you are compiling an execution plan for a minute and then t the time it starts to run the querry,. You would see that whole query is taking more than a minute. This means that, hopefully, for most of your queriesthe first time it runs isn't much longer than the second time it runs.

Transcript
Play full episode

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app