>Patrick,
>
>According to another FoxPro programmer in the office, to fully optimize the query, the index should be:
>
> INDEX ON DELETED() FOR DELETED() TAG whatever
>
>Without the FOR clause, every record's delete status is in the deleted index, a series of .T. and .F. With the FOR clause, only the deleted records are in the index.
>
>Haven't tried this myself, but he says they tested this extensively at a previous work site.
>
>HTH
Dallen,
As soon as you put a FOR clause on the index rushmore will NOT use that index anymore. So not only is the FOR clause not nercessary, but if you are hoping that Rushmore will use the index it must not be there.