Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index size growing abnormally .....Oracle bug ?
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
![]() |
![]() |