Home » RDBMS Server » Performance Tuning » How to improve performance on insertion, deletion and update
How to improve performance on insertion, deletion and update [message #65180] Tue, 01 June 2004 02:56 Go to next message
Vikash
Messages: 17
Registered: April 2002
Junior Member
Hi to all,

Wanted to know if it's possible to increase performance during insertion, deletion or update in a table that contain indexes. If yes then how?

 

Thanks,

Vikash

 

 

 
Re: How to improve performance on insertion, deletion and update [message #65181 is a reply to message #65180] Tue, 01 June 2004 04:40 Go to previous messageGo to next message
Deepak Panda
Messages: 24
Registered: May 2004
Junior Member
You may use the NOLOGGING Clause while inserting data into a table. Also you may like to disable constraints while doing Bulk loads.
Re: How to improve performance on insertion, deletion and update [message #65186 is a reply to message #65181] Wed, 02 June 2004 07:45 Go to previous message
sy
Messages: 1
Registered: June 2004
Junior Member
The NOLOGGING clause also specifies that subsequent direct loads using SQL*Loader and direct load INSERT (ie +APPEND ) operations are not logged. Subsequent DML statements (UPDATE, DELETE, and conventional path insert) are unaffected by the NOLOGGING attribute of the table and generate redo.
Previous Topic: MYSTATS table - Capture Stats?
Next Topic: Tuning/index
Goto Forum:
  


Current Time: Sun Feb 25 07:12:39 CST 2024