|
|
Re: very urgent.. how to increase the performance for the insert statement [message #19064 is a reply to message #19011] |
Wed, 27 February 2002 03:59 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
To increase the performance you can use the hint APPEND.
INSERT /*+ APPEND */ INTO ...
Set the extent large enough so that not to many extents have to be added to the table during the insert.
ALTER TABLE tablename STORAGE (NEXT 20M)
Disabling all constraint and indexes will also speed up your insert but you will then have to enable them again and rebuild the indexes.
What you can also do is to set the table to nologging.
ALTER TABLE tablename NOLOGGIN
Be carefull with this option and read the documentation before using it.
HTH
Mike
|
|
|