| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HASH_JOIN on RBO?
Steve,
The documentation prior to 8.1.6 is wrong as you said. The 8.1.6 documentation
is correct:
http://technet.oracle.com/doc/oracle8i_816/server.816/a76992/hints.htm#13547,
where it shows the correct diagram and also says
Exception:
The APPEND hint follows the INSERT keyword.
I can't think of any other SQL we need to place the hint after INSERT.
Yong Huang
yong321_at_yahoo.com
you wrote:
I have just checked the documentation on this, and unfortunately it is not very
helpful. The Oracle8i Tuning guide even says, "A statement block can have only
one comment containing hints. This comment can only follow the SELECT, UPDATE,
or DELETE keyword." which suggests that you cannot put a hint after an INSERT
keyword at all. Of course, you can and you sometimes must.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
 |
 |