Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

Table Scan

1
November 24, 2008  1:00 PM

Back To Basics: What’s the difference between a Scan and a Seek?



Posted by: Denny Cherry
Back To Basics, Index Performance, Index Scan, Index Seek, SQL Server, 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...

  Bookmark and Share     11 Comments     RSS Feed     Email a friend

1