Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
>>EMPTY is optimizable if there is an index with INDEX ON EMPTY(FIELD).
>
>Right, of course, but who would create such index? That's why I didn't even mention it.
>
>EMPTY is noted as not optimizable in the help as a note near BETWEEN and INLIST because EMPTY does not optimize the way BETWEEN and INLIST do. That is, those functions will use an INDEX ON FIELD.
>
>Yes. Or you can use IN (....), which now can hold unlimited (limited by memory) number of items.
People are saying EMPTY is not optimizable as if it is an undeniable fact. As to who might create such an index, how about those same people who use EMPTY() in a filter/where despite the "fact" that it cannot be optimized?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only