Execution plans … where do I start?
Presented by: Hugo Kornelis
SQL (the language) is not a third-generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well.
But sometimes it doesn't. Sometimes a query takes too much time. You need to find out why, so you can fix it. That's where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it's slow.
However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?
This session was part of GroupBy Europe in the Performance track.
Stay updated on GroupBy’s next online conference on October 27-28, 2020: https://groupby.org