Nov 24 2008 1:00PM GMT
Posted by: mrdenny
SQL Server, Back To Basics, Index Performance, Index Scan, Index Seek, Table Scan
Back To Basics: What’s the difference between a Scan and a Seek?
Posted by: mrdenny
SQL Server, Back To Basics, Index Performance, Index Scan, Index Seek, Table Scan
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
The basic rule to follow is Scans are bad, Seeks are good.
12 Comments
RSS Feed
Email a friend
