Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Excessive Logical and Physical I/O
Brian Peasland wrote:
>>>If I need to be corrected, then I need to be corrected. >> >>Oh well, in that case... do something about that paper showing 50% >>improvements in speed because of an index rebuild!!! ;-)
However, Howard let you get away with this:
<quote>
Contrary to some widely accepted beliefs, indexes in Oracle are not self-balancing. After a table
experiences a large number of inserts, updates, or deletes, the index can become unbalanced and
fragmented
</quote>
Lucky bastard ;-)
Cheers
Holger
Received on Fri Mar 26 2004 - 03:06:19 CST
![]() |
![]() |