Walter,
Never say never! While not likely, if the table had 9 million deleted records, a DELETED() tag may be a good idea. As you have said in the past, look at the situation in its entirety.

Regards.

>When dealing with a 20 million record table you never want an index on deleted(). Even if it contains a million deleted records; when doing any query or just using the table when set delete = ON, it downloads 19 million indexkeys from the network, which could take forever, especially when the network bandwith is limited. Another discriminating (selective) index would be far more efficient.
>
>Walter,