Subject Re: [firebird-support] Plan with udf funtions
Author Dimitry Sibiryakov
On 31 Oct 2006 at 16:07, yartax1 wrote:

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


>Select *
>from table A
>where substr(,1,4) = 'EUR_'
>with a index on
>If I run the query, the plan was PLAN(A NATURAL)!!!
>Is that correct?

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

SY, Dimitry Sibiryakov.