>>> Another observation, which I found in Help file: EMPTY() is not an optimizable function. So, instead of EMPTY() now I use ''<> myfield.

Nadya,

A safer alternative would be;

MyField <> SPACE(LEN(MyField))

because with SET EXACT OFF and SET ANSI OFF '' equals everything.