Andrus ---

If you don't have a lot of deleted records, you won't notice much difference but if you do, having a tag on DELETED() is well worth it. It really does speed things up.


>I'm using a lot of sql selects to select data from big free dbfs.
>Those tables have very few deleted records and where clauses are written so
>that Rushmore finds always a index tag to use.
>SET DELETED is ON always.
>
>Will the performance increase if I add
>
>INDEX ON DELETED()
>
>to those tables? Will select queries run then faster?
>I have read some recommendations to have index on deleted() in each table
>to avoid sequential scanning of the deleted records by select. Is this true?