Dmitry,

A very dangerous action. In general if you don't have many deleted records. the DELETED() tag only slows things down. If you've got large tables accessed over a WAN, the DELETED() tag can slow your queries down to a crawl.

The hackers guide is incomplete or plain misleading. If you've got performance problems, the please try to delete those tag and check if the situation has improved. In general there is no need at all to use them.

Walter,


>For years, I have used an index tag on expression DELETED(). I don't remember, but think, at one point I read somewhere that having tag on DELTED() helps speeding the queries. This might have been when I was still using Clipper (before I moved to VFP), I don't remember.
>
>My question is, does it really help?
>
>Thank you.