Re: Coalescing Indxes on a regular basis

On 4/10/07, fmhabash_at_gmail.com <fmhabash_at_gmail.com> wrote:
>
> So if a table does witness this massive deletion
> with no subsequent significant DML or if there is an index on a some
> sequence generated value with sporadic deletions that leaves the leaves
> unused but keeps the nodes. These leaves are never back on the free
> list.
>

If you mean a DELETE that removes all data from an index leaf block, then that is incorrect. Empty index leaf blocks go back on the freelist.

If the leaf block still has data in it, it can still be used. In the case of a sequence generated key though the space is unlikely to be reused.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l