On 31 Oct 2006 at 16:07, yartax1 wrote:

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

No.

>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?

Yes. But your query is complete equvalent of "a.zone STARTING WITH
'EUR_'" which could use index.

--
SY, Dimitry Sibiryakov.