From: Ashok Upadhyay <aupadhya@earthlink.net>
Subject: Re: Using multiple index hints on multiple tables in query?
Date: 1998/10/30
Message-ID: <363A0431.EF3EF55B@earthlink.net>#1/1
Distribution: world
Content-Transfer-Encoding: 7bit
References: <3639D51F.75801524@americasm01.nt.com>
Content-Type: text/plain; charset=us-ascii
X-Trace: burlma1-snr1.gtei.net 909772032 128.89.41.223 (Fri, 30 Oct 1998 18:27:12 GMT)
MIME-Version: 1.0
Reply-To: aupadhya@earthlink.net
NNTP-Posting-Date: Fri, 30 Oct 1998 18:27:12 GMT
Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server


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!