Piet,

I've been involved in a discussion with several people about the DELETED() tag about a year ago, The outcome was that the DELETED() tag was only helpfull in a few particular circumstances. From the top of my head:

- If you want to get maximum performance out of a COUNT command with SET DELETE ON
- If you've got significant amounts of deleted records in your table ( > 10% )
- Tables are not too large ( < 1.000.000 records )

In all other circumstances there is no significant performance gain for the DELETED() tag or a performance drop just by adding a TAG ON DELETED().

The best thing that helps to optimize your queries is to have a good understanding of how rushmore and other index-aware commands work. This isn't a quite simple topic, it's both theory and a lot of testing.

Walter,

>Some documentation (hackers guide) say dat including a tag on
>deleted() records in a table increase performance in SQL select queries.
>
>However in Foxpro Advisor there was an article that it can also slow down queries.
>
>Has anyone tested this,
>
>Please advise