Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slowness on insert statemente
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 DBAReceived on Thu Aug 12 2004 - 13:11:16 CDT