Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Slowness on insert statemente

Re: Slowness on insert statemente

From: <sybrandb_at_yahoo.com>
Date: 16 Aug 2004 06:41:02 -0700
Message-ID: <a1d154f4.0408160541.3640a18e@posting.google.com>


"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:<2o37drF6fl6oU1_at_uni-berlin.de>...
> "Sybrand Bakker" <sybrandb_at_hccnet.nl> schrieb im Newsbeitrag
> news:2lcnh0lk2jk6lue17tq70fjcq5gvn4qpnj_at_4ax.com...
> > On Thu, 12 Aug 2004 11:26:23 +0200, "Jan Gelbrich"
> > <j_gelbrich_at_westfalen-blatt.de> wrote:
> >
> > >then Oracle will leave it out to find free chunks in the middle of the
> table
> > >but will always append the new data on the end of the table.
> > >Can save some time ...
> >
> > sure, but it will put the indexes in unusable state. You might loose
> > more than you gain by doing this.
> > --
> > Sybrand Bakker, Senior Oracle DBA
>
>
> Interesting ...
> So, You do suggest *never* to
> insert /*+ append*/ ?
> If so, why would such a hint exist then if it is so harmful ?
>
> BTW I use it seldom and it becomes a little offtopic,
> as the original poster did not give any details of his problem ...

I would suggest to avoid it in situations where the affected table is accessed frequently and concurrently. But then one doesn't load directly in production tables of course.

Sybrand Bakker
Senior Oracle DBA Received on Mon Aug 16 2004 - 08:41:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US