Jerry,
Try the following:
1. Add NOFILTER clause to your query
2. Would it help to select from the Calls table first and then join with the second table?
e.g.
select T.*, Cust... from (select * from Calls where ...) T left join Cust on T.ID = Cust.ID
3. The DELETE() index may be a problem.
>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.
>
>Also, both tables have an index for "DELETED()" and each column being filtered has an index on that column.
>
>Any suggestions?
>
>Thanks,
>
>Jerry
>
If it's not broken, fix it until it is.
My Blog