Re: Indexes space use

From: Czes³aw Gryzik <gryzio_at_wasko.gliwice.pl>
Date: Fri, 21 Aug 1998 12:43:38 +0200
Message-ID: <35DD4F5A.8B5AF916@wasko.gliwice.pl>

As far as I know Oracle doing only inserts on indexes, then delete only freeing space used by table data, not space used by indexes based on table.

If you run lot of inserts/delete operations you should frequently drop/create this index or rebuild it (I don't exactly know what is better in this situation).

Hope it helps.

ThierryHuge wrote:
>
> I have a table T which have an index I
> Users run a lot of insert/delete operations on T (then on I)
> Each time the key is different. It seems the blocks allocated for I are
> not reused.
> Table T has always a few number of lines but I have a lot of extents
> allocated for I.
>
> Could someone explain how space is allocated for the index when a lot of
> insert/delete are run onto the corresponding table ?

Czeslaw Gryzik             e-mail c.gryzik_at_wasko.gliwice.pl
P.W.P.T. Wasko sp. z o.o.              tel.+48 32 230 67 21
ul. Akademicka 3A                      fax.+48 32  31 49 99

44-100 Gliwice

Received on Fri Aug 21 1998 - 05:43:38 CDT