>>So what's your opinion now? Still think IN is faster/better performance?
>
>Well, I asked you for the results. :) So, no, I'm not sure it is faster in any condition. :) Although, I would try to make the test (if possible) with all tables on local drive.
>
>Also, extremly important: close and reopen VFP between each 2 SELECTs in order to get accurate results. VFP is optimizing from one SELECT to another when this is possible. Since the SELECTs are on the same dbfs, it's almost sure some optimizations are done as you pass from one SELECT to another.
>
>Thanks for the results and I'd be interested to hear about any new results you may have.
>
>Vlad
And don't call us Gods, please! People are jealous ::).
Edward Pikman
Independent Consultant