SQL Server with Mr. Denny:

Table Scan

1

June 26, 2013  2:00 PM

Performance Tuning a Spotlight for SQL Server Query



Posted by: Denny Cherry
Database Administration, Execution Plans, Indexing, Nonclustered Index, Quest Software, SoSSE, SQL Server, Table Scan

The other day I was looking at parallel query plans on a customers system and I noticed that the bulk of the parallel queries on the...

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...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: