| Author: D.Jeya kumar(JK) 29 Aug 2008 | Member Level: Diamond | Rating:  Points: 5 |
Hi,
Index Scan will retrive all the records for the table where as a index seek will retrive a set of records.in index seek we can specify the index to get the set of rows from a table.
If the table is small we can use Index scan. because it will scan all the rows for the search where as Index seek will search
only the specify index which is mentioned.
Refer this links to know more about it,
http://msdn2.microsoft.com/en-us/library/aa964133.aspx
http://blog.sqlauthority.com/2007/03/30/sql-server-index-seek-vs-index-scan-table-scan/
Regards
JK
|