Database Reference
In-Depth Information
The output from the first query of
SETSHOWPLAN_ALL
will provide information about
PhysicalOperation
,
LogicalOperation
,
EstimateIO
,
EstimateCPU
, and
AvgRowSize
, as shown in the following screenshot:
In addition to using the
SETSHOWPLAN_ALL
TSQL statement, you can use the
SET
STATISTICS
PROFILE
statement to obtain the executed query result set, followed by an additional result set
that shows a profile of query executions. The additional information is as follows:
Column name
Description
Rows
Actual number of rows produced by each operator
Executes
Number of times the operator has been executed
Search WWH ::
Custom Search