OraFAQ Forum: Performance Tuning » How to improve performance on insertion, deletion and update

Home » RDBMS Server » Performance Tuning » How to improve performance on insertion, deletion and update

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to improve performance on insertion, deletion and update [message #65180]

Tue, 01 June 2004 02:56

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

�

�

�

Report message to a moderator

Re: How to improve performance on insertion, deletion and update [message #65181 is a reply to message #65180]

Tue, 01 June 2004 04:40

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.

Report message to a moderator

Re: How to improve performance on insertion, deletion and update [message #65186 is a reply to message #65181]

Wed, 02 June 2004 07:45

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.

Report message to a moderator

Previous Topic:	MYSTATS table - Capture Stats?
Next Topic:	Tuning/index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 23:20:03 CST 2024