Direct insert
I've seen many RTFM replies given to people because of trying something
like this:
INSERT /*+ APPEND */ INTO EMP VALUES (....)
This type of thing used to guarantee a condescending reply from people
who knew that the APPEND hint only works with sub-query, not with the
VALUES clause. Well, as Bob Dylan sings, things are changing:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements006.htm#sthref502
This is a link on 11.2 SQL reference. The following description is very
interesting:
APPEND_VALUES Hint
Description of append_values_hint.gif follows
Description of the illustration append_values_hint.gif
The APPEND_VALUES hint instructs the optimizer to use direct-path INSERT
like this:
INSERT /*+ APPEND */ INTO EMP VALUES (....)
This type of thing used to guarantee a condescending reply from people
who knew that the APPEND hint only works with sub-query, not with the
VALUES clause. Well, as Bob Dylan sings, things are changing:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements006.htm#sthref502
This is a link on 11.2 SQL reference. The following description is very
interesting:
APPEND_VALUES Hint
Description of append_values_hint.gif follows
Description of the illustration append_values_hint.gif
The APPEND_VALUES hint instructs the optimizer to use direct-path INSERT
1