Re: Using multiple index hints on multiple tables in query?

There are several other hints available for table Joins which force query to use indexes in more efficient manner. Look for Server Tuning Manual Chapter "OPTIMIZATION MODES AND HINTS " and subchapter "HINTS FOR JOIN OPERATIONS".
Those hints can be used in conjuction with ORDERED and START hints also.

Good Luck

Chan, Peter (BNR:QUAL:7S44) wrote:

> I was wondering if it is possible to use multiple index hints on
> multiple tables in a query.
>
> For example:
>
> Tables: A, B
> Indexes: indA, indB
>
> can I have a query:
>
> select /*+ index(A indA) index(B indB) */ .....
> from A, B
> where .....
>
> Thanks!
Received on Fri Oct 30 1998 - 00:00:00 CET