Typing the following command in an SSMS query window turns on the
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.
SHOWPLAN_TEXT option displays a textual representation of the execution plan. Listing 32.3 shows an example for a simple inner join query.
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 ...