ald
> > 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 be very useful, but it works
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.
Ste
> -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,
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 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
>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 hint
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 supported.
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 th
