Hi all,
In a discussion with an Oracle rep last week it was suggested we use the /*+
append */ insert hint to allow some inserts to use direct-path. The
suggestion is interesting - the business logic won't have any problems with
the limitations this implies.
Has anyone had any experience with
I can't say in regards to 7.3.x or 8.0.x, but in an 8.1.7.4, I've traced a complete
snapshot refresh and seen that Oracle is using an insert /*+ append */. Good, bad, or
otherwise, someone at Oracle believes in it.
I will say that it is very likely the hint will just be ignored if not
From experience, do not use the APPEND hint for singular inserts. You will
get tons of wasted space. Only use it for bulk inserts such as INSERT INTO
.. SELECT FROM, sqlldr, PL/SQL bulk inserts and the like.
Converting from buld inserts without the append hint to bulk inserts with
the append
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Connor
McDonald
Sent: Monday, March 17, 2003 13:34
To: Multiple recipients of list ORACLE-L
Subject: Re: Using the /*+ append */ insert hint
APPEND came in at 8.0 so it will work there.
The hint can
APPEND came in at 8.0 so it will work there.
The hint can be very useful, but it works best with
unindexed tables (that are set to NOLOGGING). If
tables are indexed, then you still might get some
benefit but the gains are not as dramatic.
Of course, anything in NOLOGGING mode often requires a
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Toepke,
Kevin M
Sent: Monday, March 17, 2003 13:24
To: Multiple recipients of list ORACLE-L
Subject: RE: Using the /*+ append */ insert hint
From experience, do not use the APPEND hint for singular
The append hint works since Oracle 8 if my memory is good.
I've used the append hint with tables in nologging mode to load a lot of
data very fast.
It works well.
You must do a backup afterwards.
If the hint is not supported, it should be ignored, like when you make a
typo in the hint's name.
To: Multiple recipients of list ORACLE-L
Subject: Re: Using the /*+ append */ insert hint
APPEND came in at 8.0 so it will work there.
The hint can be very useful, but it works best
with
unindexed tables (that are set to NOLOGGING). If
tables are indexed, then you still might get some