In all years working with FoxPro I haven't seen a single case when adding index on DELETED() slowed down a query but I've seen planty of cases when such index speed up queries significantly.
>An index tag on deleted() is normally a bad idea, UNLESS he uses VFP9. This will depend on the situation, but in most cases this index will actually slow down a select. Whether it will slow down or speed up the selects depends on many factors, the most important factor is how many records are deleted in relation to how many records are not deleted.
>
>>Add an index on DELETED() on all tables involved in the query. Make it a binary index if you are using VFP9.
>>
--sb--