Home » RDBMS Server » Performance Tuning » Insert performance with index rebuild (10gR2 solaris)
Insert performance with index rebuild [message #419111] Wed, 19 August 2009 20:32 Go to next message
othergoodboy
Messages: 1
Registered: August 2009
Junior Member
Can insert performance be improved by rebuilding indexes?

I was under the impression that index drop/disable is the way to improve insert performance. but i haven't heard about it until our developer said so.

has anybody heard/tried about it?
Re: Insert performance with index rebuild [message #419112 is a reply to message #419111] Wed, 19 August 2009 20:41 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Can insert performance be improved by rebuilding indexes?
Possibly & it may depend upon mitigating factors.

>I was under the impression that index drop/disable is the way to improve insert performance.
Some improvement on INSERT after DROP/DISABLE, not always measurably true.

>has anybody heard/tried about it?
Urban legend.

When anyone makes such claims, ask for reproducible test case that provides definitive proof.
Re: Insert performance with index rebuild [message #419126 is a reply to message #419111] Thu, 20 August 2009 00:01 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can insert performance be improved by rebuilding indexes?

Most likely it will worsen them.
Rebuild purpose is to improve (range) select performances not DML.

Regards
Michel
Previous Topic: Open cursor count is too high
Next Topic: Bitmap & Normal Index for same column - Oracle
Goto Forum:
  


Current Time: Fri Dec 09 19:35:48 CST 2016

Total time taken to generate the page: 0.11123 seconds