>>How would you explain the fact I got 2 Index seeks with your test code and my addition of populating tables?
>>
>>>No, no matter if PRIMARY KEY index is CLUSTERED or not in both cases I have INDEX SEEK.
>>>Thanks again Walter.
>
>I can't. :-)
>I even can not explain why my friend has INDEX SEEK directly w/o running any code to populate data.
Hmm, that's the most complex task - find the difference in our SQL Server environment. I ran in SQL Server 2005 SP2, AFAIK all default settings.
We need more statistics then from other people trying the same test.
If it's not broken, fix it until it is.
My Blog