Re: How to specify multiple optimizer hints

Tim Romano wrote:
> A.
> /*+ USE_NL(CUST) INDEX CUSTOMER(CUST_ZIP_IX) */
>
> B.
> /*+ USE_NL(CUST) INDEX(CUST_ZIP_IX) */
>
> C.
> /*+ USE_NL(CUST) INDEX(CUSTOMER[CUST_ZIP_IX]) */
>

The reference books are hopeless on this. There is a book (ORACLE SQL Tuning, or something similar), that explains it quite well.

In your case, if CUST doesn't have other indexes other than CUST_ZIP_IX, just USE_NL(CUST) will be enough to get it to pick the index.

If there are other indexes, then USE_NL(CUST) INDEX(CUST,CUST_ZIP_IX) if memory doesn't fail me.

HTH --
Cheers
Nuno Souto
D.C.S. P/L
e-mail: nsouto_at_acay.com.au Received on Fri Aug 14 1998 - 08:44:31 CDT