Re: Coalescing Indxes on a regular basis
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: fmhabash@xxxxxxxxx
- Date: Tue, 10 Apr 2007 15:51:21 -0700
On 4/10/07, fmhabash@xxxxxxxxx <fmhabash@xxxxxxxxx> 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
Other related posts:
