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?
Andrus