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: 25570
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: 65143
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: A question about LRU in shared pool
Goto Forum:
  


Current Time: Sat Aug 19 02:36:13 CDT 2017

Total time taken to generate the page: 0.12984 seconds