STATISTICS PROFILE
The SET STATISTICS PROFILE
option is similar to the SET SHOWPLAN_ALL
option but allows the query to actually execute. It returns the same execution plan information displayed with the SET SHOWPLAN_ALL
statement, with the addition of two columns that display actual execution information. The Rows
column displays the actual number of rows returned in the execution step, and the Executions
column shows the actual number of executions for the step. The Rows
column can be compared to the EstimatedRows
column, and the Execution
column can be compared to the EstimatedExecution
column to determine the accuracy of the execution plan estimates.
You can set the STATISTICS PROFILE
option for individual query sessions. In an SSMS query ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.