>do you mean that even though you had an index on DELETED()
>a (e.g.) LOCATE for DELETED() and ID="somevalue" is not fully optimizable??

Excatly, the infrastructure of Visual FoxPro 3 and 5 has changed. This is a major change by MS which almost no one was aware. I just found that on my 6th systems in Visual FoxPro.

There is no need for that tag anymore. No more SET DELETE ON or LOCATE & SCAN on high volume tables.