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]