>Srdjan,
>
>>good thing to do is to have dummy index
>>tag on 'deleted()' which if active, dramatically improves performance on menu
>>operations like scan/endscan ,append from,replace all etc.
>
>No this is not. It's an common mistake that the index on deleted() improves performance dramaticly. If there are not many delete records you can only degrade performce with these commands.
>
>Especially when we talk about the append command, VFP has to update the index each time when a record is added, dramaticly slowing performance.
>
>Only benefit of the DELETED() tag can be in tables where huge amounts of deleted records exists and it's not possible to get rid of them in a ellegant way.
>

Walter,
All right, you have point about append command, but think about this;
since we are talking about SCAN, If you have to scan through table with let say 100.000 records you will have much better performance having index set
on 'code' or 'Name' (or whatever) then without any index, right?
Index on 'deleted()' improves performance in MENU cases (not all as you pointed) because is fully featured INDEX file with minimal KEY LENGTH.
Well, this is at least that is what I understood and experienced.
To each it's own, I found it good up to now. I have no intention to misslead the public, this was as I sed only a HINT.
Thank you for your input, I will do some more testings
(reggarding negative impact) and I will let you people know.

Reggards to all from Cyprus