Question: what is the difference between index seek and index scan?
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.