Dear SQL DBA cover image

Why is My Query Faster on the Second Run?

Dear SQL DBA

00:00

Why Memory Is a Big Deal in SQL Servers

memory is a big deal to make your queries faster, especially on repeat runs. sequil server saves that off for you when you create the view but it doesn't know how queries are going to run the view. When you write a query using a view, single server doesn't know if you want all the columns or just some of them. It will compile an execution plan for how to run your query. This process of compiling the execution plan can take time, and it does. Sometimes it's a very small amount of time that could be a longer amount of time.

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