>Bret, Josh,

>I guess I have not hit any of those cases yet. All my apps seem to perform well with the DELETED index tag. My tables range from a few records to 5 million.

Unless the table contains significant amounts of deleted records, you'll not get any performance benefit from a DELETED() tag.

In fact, rushmore is slowing down with such low selective indexes. You may want to test performance in your cases. I would not be surpriced if you would notice significant performance gains on queries on the larger tables.

About a year ago there was a discussion regarding this subject in Thread #196021 and Thread #198031. The general outcome was that only in a very few circumstances the DELETED() index tag was helpfull.

- using a COUNT statement on a table with full optimization: The table is not read, the count is done by indexnodes.
- When creating a FILTERED SQL query result. In most circumstances you want to avoid filtered sql results because they behave different from cursors.
- When looking for DELETED records (thus looking for the minority of the table)
- When you have large amounts of deleted records in your table.

Walter,