RE: Rebuild indexes

 
if an index block gets filled up, is is split in two -- resulting in two index
blocks with 50% freespace. (there is an exception for the rightmost block, by
the way)
in other words, you don't need deletes to create freespace in an index; inserts
will do.
now, when you rebuild the index, all leaf blocks are repopulated from scratch --
thus resulting in a smaller overall size.
kind regards,

Lex.
 
------------------------------------------------------------------
Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Peter Dixon
Sent: Sunday, May 22, 2005 19:46
To: oracle-l@xxxxxxxxxxxxx
Subject: Rebuild indexes

I have an application where data is never deleted, I have just rebuilt an index
which was previously 4gb in size and its now 3gb in size. Can anybody explain?


--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Other related posts: