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