Hi Keith,

Snipped.
>>You may want to try an Index on deleted(). If you environment settings
>>have the value set. It's worth a try anyway.
>>
>I don't understand it, but it sure worked. I indexed on DELETED() and
>all of a sudden I'm getting full optimization. I *will* be asking
>somebody (pro'ly Kevin Levy) about this in Costa Mesa! :-)

I'm just very curious...what is the difference in performance?

If your table has no deleted records why not just SET DELETED OFF. That should be faster in all cases.

Was it just a typo, SYS(3054,2)? I don't remember if it's good for VFP5.0, but it errors in 6.
Don't you want SYS(3054,11)? Was that what you were using?