Re: index blocks reuse

From: Tanel Poder <tanel_at_peldik.kom>
Date: Thu, 19 Sep 2002 23:02:33 +0300
Message-ID: <3d8a2d0d$1_1@news.estpak.ee>

> Question is : Will the space in the index be reused after deletion?
> Since the leaf pages in the index will have ordered data, deleted the
> data from the table in date order should free up 100 per cent space in
> such index blocks. Would this space be used automatically for new
> index data (since there are new insertions to the table daily) or do
> I have to coalesce/rebuild the index to reuse thus freed space?

Hi!

The index blocks containing no rows are put on freelist, thus can be reused for different keys than the original ones residing in it.

If you have even only one row left in leaf block, only keys in range defined in branch block pointing to leaf can be inserted there.

Tanel Poder. Received on Thu Sep 19 2002 - 15:02:33 CDT