1
November 24, 2008 1:00 PM
Posted by: Denny Cherry
Back To Basics, Index Performance, Index Scan, Index Seek, SQL Server, Table Scan
Back To Basics: What’s the difference between a Scan and a Seek?
Posted by: Denny Cherry
There are a few basic operations which SQL will perform when looking for the data that you need. Here they are listed in the order of worst to best.
- Table Scan
- Clustered Index Scan
- Index Scan
- Clustered Index Seek
- Index Seek




