Hi, Hilmar.
>>>What about to change this Index. Just add a Filter for .NOT. DELETED() in it.
>>
>>Well, I though about that, but as it would ruin Rushmore optimization, I'm trying to avoid filters.
>
>If you need it for Rushmore Optimization, you can create two indices, on the primary key or alternate primary key: one regular, without a filter, for Rushmore Optimization, and an index marked as "primary" or "candidate", with a filter.
I find out that VFP 9 fully optimizes queries using the candidate tag with a !deleted filter, so the issue is solved (migrating to VFP 9 was already on the plan).
Thanks a lot!