
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.