In addition to the excellent explanations you have already received,
rebuilding
this index will cause a considerable amount of extra activity during
subsequent
inserts while the index bulks itself back up to its former size.
Why are you rebuilding it? There is generally no good reason for doing so.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 5/22/05, Peter Dixon <peterdixon001_at_hotmail.com> wrote:
>
> 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 Mon May 23 2005 - 11:31:26 CDT
