Reading execution plans
A video from the Apprendre SQL Server series
less than a minute
Execution plans in SQL Server can be intimidating. You tell yourself it would surely be worth understanding them. In this video I take you through reading SQL Server query execution plans step by step, using SQL Server Management Studio and Plan Explorer.
The video is in French.
Sites and tools mentioned:
- Plan Explorer: https://www.solarwinds.com/free-tools/plan-explorer
- Hugo Kornelis’s site: https://sqlserverfast.com/epr/
Chapters:
- 00:00 Reading execution plans
- 03:00 Displaying the estimated execution plan
- 13:28 Seeing the index suggestions
- 14:20 Reading the plan details
- 19:50 Comparing with the actual plan