Re: insert and append hint

In article <3B4DD464.91772C81_at_usa.net>, Tommy says...
>
>
>Question:
>
>Does the append hint give me the same benefit on insert /*+ append */
>into...values; like on insert /*+ append */ into...select...;
>
>Thanks.
>Tommy
>

nope. it is for bulk, direct path large scale loads of data.

singleton inserts are processed as normal.

see
http://technet.oracle.com/doc/oracle8i_816/server.816/a76965/c21dlins.htm#7917

for details.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp