Subject Re: [firebird-support] No index used for join on 'starting with'
Author Woody
From: "Rick Debay" <rdebay@...>

> Damn. Anyone know why the heck FB won't use an index in a join with
> 'starting with'?
> FWIW, I ran the natural part of the query to generate a bunch of "starting
> with 'xyx' or" and appended them to query the other table. Luckily I
> didn't hit any query limits.

I'm not near as proficient as everyone else trying to help, but would using
the old style syntax force it to use the index on table2?

select t1.*, t2.* from table1 t1, table2 t2
where t1.unindex_varchar containing 'foo' and
t2.indexed_char14 starting with t1.indexed_char10

Woody (TMW)