Hi Tim,
My advise to you is to read carefully Oracle7 Server Tuning from Oracle7
Server Documentation (I used release 7.3.3) - especially chapter 7:
"Optimization Modes and Hints".
In your specific problem:
1. Using hint USE_NL you must first use hint ORDERED and put the table names
in the FROM clause in proper order
2. Hint that suggests using specific index has a following syntax:
INDEX (table_name index_name)
3. If you want to use multiple hints you just have to put them in one
comment (beggining with "+") and separate them with spaces
4. So the hint-set you need would be like this:
/*+ ORDERED USE_NL(CUST) INDEX(CUST CUST_ZIP_IX)*/
Darek
Received on Tue Aug 11 1998 - 03:27:54 CDT
