>Thanks for the lowdown.
>
>The tables actually don't have many deleted records so I think I can assume I won't run into any major performance issues.
>
>Although saying that - any performance increase is good, so I may consider putting that index on all tables, after all, it only requires a few extra megs here and there.
>
>Kev

Kev,

The performance hit isn't from having the index, it's from FoxPro retrieving the index across the wire when you access the table. Without the index it goes right to the records you need, gets them, and then checks those few locally for their DELETED status.

The best thing for you is to read the FPA article from last Spring about 4 times! ;-)