Re: Question about Oracle Indexes

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Mon, 5 Nov 2001 09:09:27 -0500
Message-ID: <9s66hc$10vnnv$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"waltervdv" <marcus.kuehl_at_t-online.de> wrote in message news:b2677297.0111050606.24d5f3f5_at_posting.google.com...
> Hallo !
>
> Is it true that Oracle (8i) does not remove dependent index-entries
> when a row in a table is deleted and that the only way to remove
> entries in an index is to rebuild the index ("alter index xyz
> rebuild")?
>
>
> Thanks ,
>
> Marcus

No. As I understand it, Index entries are removed from the leaf blocks, however empty leaf blocks are not automatically freed up until you either coalesce or rebuild the index.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO+adlGm5A4kkb4ZsEQIe5QCfRJfTmV+r/4ooXXMkVd6U9R4LKP8An1kN C66qlTdaEIVtQDSB92yA+YNJ
=s6p5
-----END PGP SIGNATURE----- Received on Mon Nov 05 2001 - 08:09:27 CST