Jay,
Index blocks can be reused, but unlike a table block,
they are not reused until *all* data is removed from
the block.
So if you remove most rows, it won't help if most blocks
still have a pointer to a row.
Jared
On Wednesday 15 August 2001 13:48, Miller, Jay wrote:
I'm puzzled.
We
Thanks to you and Kevin!
You'd think I'd have noticed this behavior sometime before, but obviously
not.
Hmm, I'm also thinking now about my partioned tables in the datawarehouse,
some of which have a global index on them. After exporting and dropping an
older partition, I assume all that space
Jay;
Yep. Thats the way it works. Deleteing rows does not free up the index
space. I think you hit on the only way to get out of that. Do a Rebuild
Index.
-Original Message-
Sent: Wednesday, August 15, 2001 3:48 PM
To: Multiple recipients of list ORACLE-L
I'm puzzled.
We had a
Index blocks remain when all the leaves are gone. It's late and I'm late
for going home but basically, you deleted rows from the table. The index
removes those pointers but does not otherwise reorganize itself. After you
do a major DML on a table, rebuild the index.