September 2010
Intermediate to advanced
1704 pages
111h 8m
English
SHOWPLAN_TEXTTyping the following command in an SSMS query window turns on the SHOWPLAN_TEXT option:
SET SHOWPLAN_TEXT ON GO
Setting this option causes the textual showplan 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, you click the Advanced item and check the SET SHOWPLAN_TEXT option.
The SHOWPLAN_TEXT option displays a textual representation of the execution plan. Listing 36.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 ...