Rick, 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, Ann [Non-text portions of this message have been removed]
