December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...