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

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
App store bannerPlay store banner