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@xxxxxxxxxxx> 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? > > > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l