>Hi Ricardo,
>
>I found it. Search for Rushmore, then Chapter 15: Optimizing Application ...
>Lots of very interesting info... Then Creating Basic Optimizable Expressions:
>See carefully.
>
Note ISBLANK( ) and EMPTY( ) are not optimizable by Rushmore.
>
>Nadya
>
>P.S. Jim, how do you explain this?
I explain it the same way I explained the TYPE() issue. Look carefully at the examples below;USE Table
INDEX ON Name TAG Name
SELECT * FROM Table WHERE EMPTY(Name)
INDEX ON EMPTY(Name) TAG EmtpyName
SELECT * FROM Table WHERE EMPTY(Name )
SELECT * FROM Table WHERE EMPTY(Name ) = .T.
The docs are saying that EMPTY() does act as an optimizable operator, but it does work as one of the expressions if there is an index on EMPTY(Whatever).
