>All,
>
>
>I'd like to see that there is a possibility to have indexes scoped to non deleted records (like a filtered index), but which can be used by rushmore.
>
>Most VFP developers use SET DELETE ON for their applications, so all DML commands are scoped to nondelete records. In the current situation an index (might) carry an enormous amount of data which refers to records which are not to be used anyway. This CAN be a real performance killer.
>
>In many situations applications might benifit from this feature. Also you can implement better RI constraint because RI, in it's current implementation, is scoped to non deleted data. By this it won't be neccesary to add a filter on primary indexes anymore.
>
>Walter,

There have been many long discussions about this here on the UT. I think the decision was that you may get a performance increase by having an index on DELETED() then adding WHERE NOT DELETED() to your query.