RE: Rebuild indexes

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 24 May 2005 03:41:04 -0500 (EST)
Message-Id: <20050522181658.640AC42BD@node42.naturaljoin.lan>

 

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Dixon
Sent: Sunday, May 22, 2005 19:46
To: oracle-l_at_freelists.org
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 Received on Tue May 24 2005 - 04:44:00 CDT