Hi,

One question, did fb 1.5 benefits of indexes with udf functions?

Example:

I have next query:

Select *
from table A
where substr(a.zone,1,4) = 'EUR_'

with a index on a.zone

If I run the query, the plan was PLAN(A NATURAL)!!!

Is that correct?

Must to create two columns; one with zone and another with zone_prefix
to benefit of index?

Thanks.
Yartax.