>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.