May 5, 2011 at 3:26 am
Hi,
I am analysing execution plan of a queries. I get two terms index scan and index seek . Index scan mean the query does not use the index and index seek means the query uses the index mentioned in the query execution plan. Am I right?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
May 5, 2011 at 3:33 am
No, both use the index that they say they use. The difference is in how they use it.
A seek uses the upper levels of the b-tree to locate a row or start of a range or rows. A scan just reads the leaf levels from either the beginning or end, and usually reads the entire leaf level.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply