O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required