Monday, February 13, 2012

about Index

Hi all~
can anybody tell me What is the difference
Index Seek AND Index Scan
Thanks~Hi all~
can anybody tell me What is the difference
Index Seek AND Index Scan
Thanks~

Well, if our criterion is (LIKE 'A%'),we do one single lookup in our index and are able to look through the non-clustered index to find a continuous range of data.This kind of lookup where we can go to a particular spot in the index is called a Index Seek.
You better see the BOL about this topic

Index Seek (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_119q.asp)
Index scan (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_119q.asp)

No comments:

Post a Comment