Difference between INDEX SEEK AND INDEX SCAN :
- INDEX SCAN:
The index scan will scan all the data in the data page. Index scan is useful if the table has small amount of datasets. The index scan can be considered as a table scan.
- INDEX SEEKS:
The index seek is good at performance optimization point of view. Index seek will only seek for the satisfying query conditions.