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_ALL
The SHOWPLAN_ALL option displays the same textual execution plan information as the SHOWPLAN_TEXT option, and it also provides additional columns of output for each row of execution plan output. These columns provide much of the same information available in the graphical execution ToolTips, and the column headings correspond to the ToolTip items listed in the “Execution Plan ToolTips” section, earlier in this chapter. Table 32.1 describes the information provided in the data columns returned by the SHOWPLAN_ALL option.
TABLE 32.1 Data Columns Returned by SHOWPLAN_ALL
Tip
When you are displaying the SHOWPLAN_ALL information in SSMS, ...