>
>I just want to know does VFP's SQL read the deletion mark of all the records, or only the retrieved records. That would make a difference. BTW, how come nobody mentioned this tag in 2.x? Not that I can remeber.

I remember hearing about this in 2.x, but I don't think most people payed attention because there was no way to know if a query was optimized or not.