2min chapter

Dear SQL DBA cover image

Why is My Query Faster on the Second Run?

Dear SQL DBA

CHAPTER

Query Store Tracks Compile Time and Execution Plan Components

If you enable query store, it will track compile time as well as a bunch of other com ation metrics. This is available in data bases in all aditions so you can do this in standard edition. So whenever i wonder how much of this was compile time, i will come up with a version of the query i can run in a place that's safe and use set statistics time or look in the plan. That's the most often things i do. Is this worse when you have a lot of joint like you mention a their complex views? I would say sometimes.

00:00

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode