Output

Causes SQL Server to display information about the amount of physical and logical IO activity

generated by Transact-SQL statements. Physical IO is related to accessing data pages on disk

and logical IO is related to accessing data pages in memory (data cache).

syntaxsql

The following table lists and describes the output items.

Name of the table.

Number of seeks or scans started after reaching the leaf level in any direction to retrieve

all the values to construct the final dataset for the output.

Scan count is 0 if the index used is a unique index or clustered index on a primary key

and you’re seeking for only one value. For example,.

Scan count is 1 when you’re searching for one value using a non-unique clustered index

defined on a non-primary key column. This process is done to check for duplicate values

for the key value that you’re searching for. For example,.

Scan count is N when N is the number of different seeks or scans started toward the left

or right side at the leaf level after locating a key value using the index key.

Number of pages read from the data cache.

Number of pages read from disk.

Expand table

Output item

Meaning

varchar(max)

nvarchar(max)

varbinary(max)

Table

Scan count

WHERE Primary_Key_Column =
<value>

WHERE
Clustered_Index_Key_Column = <value>

logical reads

physical reads

SET
STATISTICS
IO
{
ON
|
OFF
}