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?

Report message to a moderator

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: 26766
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.

Report message to a moderator

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: 68653
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 05:14:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.