>I have a SCAN loop with a nested SQL Select statement (to check for duplicates in related table on common field).
>
>The application can take up to 6 seconds to execute SQL Select against table with 223,000 records, which seems very slow to me. In VFP 8.0 doc it says that SQL statements attempt to optimize, and do so if possible, but don't use Rushmore optimization. Is this true? If so, what do I do to speed up this operation?
>
>Fz - Boston MA
Don,
Where in the docs do you see verbage about not using Rushmore? Can you post the sentence?
Please post your SELECT statement, and tell what index expressions exist on the tables involved in the SELECT.
Thanks,
Steve Gibson