>>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%