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)