Re: HELP: Large ORACLE Tables > 3million rows

Ren=E9 Brisson wrote:
> =
 

> My experience on this is based on tables with from 100.000 to 3.000.000 r=
 ecords.
> I've experienced a remarkable good performance doing inserts, especially=
 

> when using oracle arrays thus inserting for instance 100 records a time.
> =
 

> I have however experienced performance problems updating records in
> large tables.
> =
 

> If large updates or deletes has to be done, for instance doing yearly cle=
 an-up I can
> stringly recommend dropping indexes before doing cleanup and recreation
> afterwards.
>

If you are doing large numbers of updates or deletes for clean-up purposes, I would also recommend dropping any foreign key references to the table. Even with small tables (less than 100,000 rows) I have had a single row delete take over a minute due to number of child tables referencing it. I guess that's the price we pay for data integrity.

Vince Received on Wed May 15 1996 - 00:00:00 CEST