RE: Index Rebuilds
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: "Stalin" <stalinsk@xxxxxxxxx>
- Date: Fri, 4 Aug 2006 21:28:49 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
