Differences between SQL server 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. We will walk you through the major differences between Index seek and Index scan.