Search This Blog

Monday, November 21, 2011

Best Sql Server Interview Questions 2000/2005/2008 : Part 4

Difference between INDEX SEEK AND INDEX SCAN :

  • INDEX SCAN:
The index scan will scan all the data in the data page. Index scan is useful if the table has small amount of datasets. The index scan can be considered as a table scan.
  • INDEX SEEKS:
The index seek is good at performance optimization point of view. Index seek will only seek for the satisfying query conditions.

Popular Posts