>Hi,
>I did some testing a couple of weeks ago checking all the VFP9 changes and their effects on SQL to see if any differences.
>The test dbf had 10 Million records, I randomly inserted 100 records thru it and deleted 100,000 records for the test.
>
>The following SQL executed in 0.05sec once I got it Fully optimized.
>
>
>SELECT RECNO() AS RP, * FROM invh WHERE ALLTRIM(BATCHNO)="2000" ORDER BY lastname, firstname INTO CURSOR aa nofilter
>
>
>You need a DELETED() index as well as the correct indexes so that rushmore can fully optimize.
There is seldom a need for DELETED() index. If it's on your local drive it will help. Over the network it won't.
Restart VFP between trials to eliminate caching and you'll see.