Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index Rebuilds

RE: Index Rebuilds

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 4 Aug 2006 21:28:49 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF615110@MSXVS04.trivadis.com>


Stalin

> Yes, regular coalesce after rebuild would solve the problem, but is
> there a permanent solution for these ever growing index other than
> regular coalesce.

The only option I see is to use a reversed index. If I correctly understand what your application is doing it could lead to a very nice reutilization of the space in the leaf blocks. But, of course, range scans on the index will no more be available.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 04 2006 - 14:28:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US