>If an app uses Views for all it's data entry - is there any improvement of performance when the Base tables are indexed on DELETED()?
>
>Thanks
>Kev

Kev,

Only you can determine this by testing with your particular data. A lot of the value of the DELETED() index depends on the number of deleted records in the tables. In general, FoxPro is often faster when there are NO indexes on fields with only a few discrete values, including DELETED() and gender.