>I have a VFP9 Win App that uses the below query. How can I speed up this query?
>
>The SYS(3054, 1) reports that "Rushmore optimization level is Full" for both tables. But the query takes about 5 seconds to execute. One table has about 600,000 records and the other has about 50,000. The number of rows returned from the query should be around 40.

SYS(3054,1) only tells you about optimization of filters. Use SYS(3054,11) to find out whether the joins are optimized, too.

Tamar