Tables A & B both have indexes on the nullable IND_COL column.
A hint has been supplied suggesting that these indexes should
be used. The VALUE column in both tables is unindexed.
SELECT /*+ index(A) index(B) */ *
FROM A,B
WHERE A.ind_col = B.ind_col
AND A.value = 1
AND B.value = 2
- Hints should not reference the schema name.
Eg: SELECT /*+ index(scott.emp emp1) */ ... should not be used.
Alias the tablename instead and use the alias in the hint.
"Bhasker Murthy" <tnb_at_vwebsol.com> wrote in message
news:f8ea702d.0201231447.71a2b949_at_posting.google.com...
> Hello,
>
> Can someone tell me how I can hint to the Oracle Optimizer to use
> multiple indexes from different tables? I haven't been able to get
> hold of the syntax.
>
> Thanks,
>
> Bhasker
Received on Wed Jan 23 2002 - 17:09:49 CST
