Subject Re: [firebird-support] No index used for join on 'starting with'
Author Ann Harrison

It's not going to help in the short run, but I would submit this as a bug.

This query uses natural for both tables, when I expected it to use an
> index for the join.
> select *
> from table1 t1
> join table2 t2 on t2.indexed_char14 starting with t1.indexed_char10
> where t1.unindex_varchar containing 'foo'
Good luck,


[Non-text portions of this message have been removed]