Branch blocks can be re-used when empty
(at least in recent versions of Oracle).
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Keith Boulton wrote in message
<38c94d91.27118680_at_read.news.globalnet.co.uk>...
>On Fri, 10 Mar 2000 14:39:39 +0100, "Sybrand Bakker"
>As I understand it, there are problems with deletions such that if a
>leaf block is cleared of all entries, it becomes available for re-use,
>but an index node block is never re-used even when it becomes empty.
>The implication of this is that index space usage may grow over-time
>because it contains a lot of unused blocks, but this will not be a
>performance issue because the index is always balanced.
>
>
>
Received on Fri Mar 10 2000 - 00:00:00 CST
