SHOWPLAN_TEXT
Typing the following command in an SSMS query window turns on the SHOWPLAN_TEXT option:
SET SHOWPLAN_TEXT ONGO
Setting this option causes the textual execution plan output to be displayed in the results panel but does not execute the query. You can also enable the SHOWPLAN_TEXT option by choosing the Query Options item from the Query menu. In the Query Options dialog, click the Advanced item and check the SET SHOWPLAN_TEXT option.
The SHOWPLAN_TEXT option displays a textual representation of the execution plan. Listing 32.3 shows an example for a simple inner join query.
Tip
When you are displaying the SHOWPLAN_TEXT information in SSMS, it is usually easiest to view if you configure SSMS to return results to text rather than as ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
