Back To Basics: What’s the difference between a Scan and a Seek?
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.