From: "Rick Debay" <rde...@accessrxs.com> > 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)