Read the execution plans
Video from the Learn SQL Server series
less than a minute
Execution plans in SQL Server are sometimes scary. You say to yourself, it would surely be worth understanding something about it. In this video, I suggest you learn little by little how to read query execution plans in SQL Server, using SQL Server Management Studio and Plan Explorer.
Links to sites and tools:
- Plan explorer: https://www.sentryone.com/plan-explorer
- Hugo Kornelis’ website: https://sqlserverfast.com/epr/
Chapters:
- 00:00 Read the execution plans
- 03:00 Show estimated execution plan
- 13:28 See index suggestions
- 2:20 p.m. Read plan details
- 19:50 Compare with the completed plan