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

Boris,

Is there a performance problem or is it you just want to understand? SQL's cost based optimizer is complex and takes many things into account. Unless you're experiencing performance problems I would not worry too much about it.

Walter,