Re: Index size growing abnormally .....Oracle bug ?

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: 2000/03/11
Message-ID: <38ca1e3e.757609@read.news.globalnet.co.uk>#1/1

On Fri, 10 Mar 2000 23:39:03 -0000, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>Branch blocks can be re-used when empty
>(at least in recent versions of Oracle).
>

I'm more than happy to stand corrected. I thought I saw a post about this a while ago saying that because of impact on concurrency, branch blocks may not be cleaned up - I must have been imagining it.

However, this still leaves the problem of how indexes can grow following a series of insertions and deletions if all preceding rows are deleted, since if all rows are deleted from an index block it should be available for re-use and the index should reach an equilibrium size. Received on Sat Mar 11 2000 - 00:00:00 CST