Shortcut: Compare query plans in SQL Server Management Studio

added by DotNetKicks
12/6/2018 2:24:40 PM

1 Kicks, 2621 Views

One of the advantages of SQL Server Management Studio (SSMS) is that it can be used to analyze queries, not just to execute them. There are two basic types of query plan: estimated execution plans, and actual execution plans. For a typical query, I can obtain the estimated execution plan, by hitting Ctrl-L, choosing the ...