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