Database Reference
In-Depth Information
The results are shown in the following screenshot:
It should be observed that, there are additional commands that can be used to return
the query and batch execution statistics information using
SET
STATISTICS
IO
,
SET
STATISTICS
TIME
,
SET
STATISTICS
PROFILE
, and
SET STATISTICS
XML
statements.
These are different to
SHOWPLAN
commands, which return the actual execution of statements
and the
SET
STATISTICS
IO
command, which returns disk activity generated during the
query execution. The
SET
STATISTICS
TIME
command returns the number of milliseconds
taken to parse, compile, and execute each statement executed in the batch.
Search WWH ::
Custom Search