>>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.