>>Not sure why the SQL Server version is obsolete. <g>
>>
>>Anyway, I'm also not sure why do you put where condition in the JOIN? Is there any specific reason for that?
>>
>>I'm going to play with your sample, but you forgot to add table populating code.
>
>There is no need to populate any records in both tables.
>Just watch Execution plan.
>
>I put Filter in JOIN so I could Get INDEX SEEK.
>The strangest thing is that IF I create that index (on Test2) AS PRIMARY KEY I get INDEX SEEK.
>I just want to know WHY this happens :-)
>
>Grrrr, obsolete, HA!
>I just checked that word in Dictionary.
>I was sure that it means "there is no meaning what version you will use".
Irrelevant is the word you're probably looking for.