Re: Slowness on insert statemente

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Fri, 13 Aug 2004 08:59:17 +0200
Message-ID: <2o37drF6fl6oU1@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 ... Received on Fri Aug 13 2004 - 01:59:17 CDT