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