>>>>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.
If it's not broken, fix it until it is.
My Blog