>>>>>>>I got 2 min. records in both tables now one to 1. My queries now take forever.
>>>>>>>
>>>>>>>I guess I would have to delete couple of records <g>
>>>>>>
>>>>>>:o)
>>>>>
>>>>>The idea was to test performance of a direct query vs. subquery, which is supposed to be slower.
>>>>>
>>>>>BTW, do you know how can I take Execution plan info into a file?
>>>>>
>>>>>Another interesting info - my queries just finished and the subquery took 44.78% while the straight one took 55.22%
>>>>
>>>>I have only SSMS installed here and when I get Execution plan I could right-Click on it and save it as file (It is a XML file, not pure text one)
>>>>Maybe the same is valid in QA?
>>>
>>>Nope, I tried. I hope to get SQL Server 2005 to play with.
>>
>>You could download SSMS Express. It will work with SQL Server 2000.
>
>May be from a different place. I'll think about it. I also need an SP4 for SQL Server 2000.

http://www.microsoft.com/downloads/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en