>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,
I think you misunderstood. You will get a performance penalty if there are not a lot of deleted records. You will only get a boost if the percentage of deleted records is relatively high.

HTH.