Home » SQL & PL/SQL » SQL & PL/SQL » very urgent.. how to increase the performance for the insert statement
very urgent.. how to increase the performance for the insert statement [message #19011] Mon, 25 February 2002 23:13 Go to next message
ksr
Messages: 112
Registered: January 2002
Senior Member
Hi,
I have a table with 5 indexes.
The table contains around 15 columns and around 100000 records.
When i give just a simple insert statement it takes lot of time.
How can i decrease the insertion time(increase the performance).
Re: very urgent.. how to increase the performance for the insert statement [message #19019 is a reply to message #19011] Tue, 26 February 2002 03:45 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
performance will decrease if there are several index exist form the table, as oracle update all the indexes to refelect the changes
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 Go to previous message
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
Previous Topic: Re: How can Insert Time Value alone into Date field ?
Next Topic: Procedure Error
Goto Forum:
  


Current Time: Thu Mar 28 12:25:56 CDT 2024