>>No problem.
>>I am still not sure what happens.
>>Why if the index is primary it is used no matter what, if it is not it is not used.
>>If this is so what are the purpose of non primary indexes?
>>Because when you use JOIN you want to have fields from JOINed table, isn't it? :-)
>
>I got Index seek in both cases after I populated the tables. However, how can I copy the execution plan to the clipboard?

No need, I believe you.

INDEX SEEK for Test2?
With NO Primary key for it?
I just sent this test to my friend in Canada and she got the same result:
INDEX SEEK for first one and TABLE SCAN for second.