Question: what is the difference between index scan and index seek in sql server?
Answer: DIFFERENCES BETWEEN SQL SERVER CLUSTERED INDEX SCAN AND INDEX SEEK. Index scan means it retrieves all the rows from the table and index seek means it retrieves selective rows from the table. INDEX SCAN: ... Thus, a scan is an efficient strategy if the table is small or most of the rows qualify for the predicate.