>"Rushmore optimizes queries that test the deleted status of records if the table is indexed on DELETED( )."
>
>I have rea this on a number of occassion but have not figured out how to put this in a query. Any one ever dothis before? It sounds like I sound do it all the time.

There have been several posts here saying that this is not necessarily a good idea. If you do not have a large number of deleted records, then it counter productive to create this index.

If you had a query like select * from mytable where myfield = somevalue and !deleted() or if you you performed the same query without the !deleted() clause and had SET DELETED ON, Rushmore would invoke the use the DELETED() index. This could lead to performance issues because too many records would look like they were candidates to match the criteria.

However, if a large percentage of your table consists of deleted records, then it would be beneficial.

HTH.