>>Hi,
>>
>>I am wondering if the EMPTY() function is Rushmore optimizable. I can't find any documentation about this matter. Can someone confirm this?
>>
>>Thanks!
>
>I think it is not, since the manual doesn't mention it. Therefore, in some cases it might be preferable to use empty(MyField) than to use MyField = 0, which is optimizable.
It does say that it's not optimazable. See Programmer's Guide Chapter 15: Optimizing Applications for details.
>
>Remember that sometimes too much optimization makes your application slower. It all depends how many records are returned for each individual part of an "optimized" expression. If Visual FoxPro has to get too many records (from the index) for an expression like "MyField = 0", then the "optimization" will be too slow.
>
>Hilmar.
--sb--