Scan count    
Number of seeks/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 are seeking for only one value. For example WHERE Primary_Key_Column = <value>. 
Scant count is 1 when you are searching for one value using a non-unique clustered index which is defined on a non-primary key column. This is done to check for duplicate values for the key value that you are searching for. For example WHERE Clustered_Index_Key_Column = <value>. 
Scan count is N when N is the number of different seek/scan started towards the left or right side at the leaf level after locating a key value using the index key.


Scan count is N when N is the number of different seek/scan started towards the left or right side at the leaf level after locating a key value using the index key - Зачем искать, если значение уже найдено?

никто не знает?

вопрос офигенно сформулирован 

Я хочу разобраться в логике процесса.
Для чего сканировать если искомое найдено?

чтобы искомое было найдено нужно сканировать
ваш К.О.

Это сообщение отредактировал(а) Zloxa - 5.7.2013, 15:18