Oracle index storage

From: <tofran_at_hotmail.com>
Date: Tue, 20 Oct 1998 09:59:56 GMT
Message-ID: <70hmuq$2n6$1@nnrp1.dejanews.com>

Can I get some info/help about how Oracle treats index storage ?

My problem is that I have a big table with heavy inserts and deletes and my only unique index on that table is constantly growing, so I have to make a reorganisation on that index often.

I suspect that deleted rows only are marked as deleted in index as the index grows in extents despite of the deletes I make on it.

Is there any methods to reuse the storage in index that are deleted ?

NOTE!! I can not use update as it is new data with different key I get constantly.

I will appriciate any comments and thanks in advance.

Best Regards
Tom Frank
tofran_at_hotmail.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 04:59:56 CDT