Toggle Actual Execution Plan [CTRL+M]

According to SQL Server 2005 Books Online (July 2006 Refresh), there is no keyboard shortcut to display the actual execution plan for a query. The documentation states:  Include actual execution plan in the query output -> No equivalent.

This appears to be a strange omission, especially given that CTRL+L can be used to display the estimated execution plan. The good news is that this frustrating omission appears to be an error in the documentation, rather than the product. Simply key in CTRL+M to toggle the display of the actual execution plan… Happy tuning… FTD

This entry was posted in SQL Server. Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s