Re: Slowness on insert statemente

From: Antoine BRUNEL <antoinebrunel.yahoo.fr_at_nospam.fr>
Date: Fri, 13 Aug 2004 22:05:58 +0200
Message-ID: <411d1f26$0$29387$79c14f64@nan-newsreader-05.noos.net>

Hi from Paris

this is wrong: using /*+ append */ still maintains indexes on tables....

I suspect in our case there are subtiles differences between both tables: indexes, triggers, physical location, etc... as the actual size of an Oracle table doesn't influence insert speed.....

Cdlt

"Sybrand Bakker" <sybrandb_at_hccnet.nl> a écrit dans le message de 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
Received on Fri Aug 13 2004 - 15:05:58 CDT