RE: Using the /*+ append */ insert hint

2003-03-17 Thread Connor McDonald
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

RE: Using the /*+ append */ insert hint

2003-03-17 Thread Stephane Paquette
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

RE: Using the /*+ append */ insert hint

2003-03-17 Thread Grant Allen
> -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,

Re: Using the /*+ append */ insert hint

2003-03-17 Thread Connor McDonald
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

RE: Using the /*+ append */ insert hint

2003-03-17 Thread Grant Allen
> -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

RE: Using the /*+ append */ insert hint

2003-03-17 Thread Toepke, Kevin M
>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

Re: Using the /*+ append */ insert hint

2003-03-17 Thread Darrell Landrum
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.

Using the /*+ append */ insert hint

2003-03-17 Thread Grant Allen
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