Insert performance with index rebuild [message #419111] |
Wed, 19 August 2009 20:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #419126 is a reply to message #419111] |
Thu, 20 August 2009 00:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68674 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
|
|
|