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

Home -> Community -> Usenet -> c.d.o.server -> Index Coalesce vs Index Rebuild

Index Coalesce vs Index Rebuild

From: Charles Davis <cdavis10717_at_comcast.net>
Date: Wed, 23 Jun 2004 17:05:29 -0400
Message-ID: <EdOdndaskMoSbUTdRVn-jw@comcast.com> 





Re: Oracle 9.2:



Does an Index Coalesce basically accomplish what an Index Rebuild Online
does?



Is it faster? Slower? Lower-impact?  Logged?



I have developers wanting to use this instead of a daily index rebuild
process each night.



Opinions are welcomed.



Thanks.



Charles
Received on Wed Jun 23 2004 - 16:05:29 CDT












Original text of this message













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