Re: Running time of index rebuild

From: Tim Gorman <tim_at_evdbt.com>
Date: Wed, 05 Jun 2013 18:50:39 -0600
Message-ID: <51AFDCDF.5070109_at_evdbt.com>

My apologies for not keeping track of this thread, and I have to admit that I don't even know what the OP was asking, but whenever I see a prolonged discussion on index drop/recreate or rebuild, I always have this indefinable urge to remind (or inform) of the ALTER INDEX ... COALESCE command, which often accomplishes exactly what people may have wanted from drop/recreate or rebuild, but in a kinder, gentler fashion?

Oracle has some decent documentation on this too ("http://docs.oracle.com/cd/E11882_01/server.112/e25494/indexes002.htm#i1006415").

I'll scuttle back under my rock now...

On 6/5/2013 12:00 PM, rjamya wrote:
> I may be wrong, but wouldn't you need a whole new temporary segment for
> rebuild in addition to existing index? so you might actually use more space
> until rebuild operation is complete. And if you have maintenance window,
> why not just drop old one and re-create? So the new index will reuse
> recently freed space as well?
> Raj
>
>
> On Wed, Jun 5, 2013 at 10:56 AM, Ingrid Voigt <giantpanda_at_gmx.net> wrote:
>
>> My suggestion for the maintenance window prod would be 16 hours, do you
>> have a better idea?
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 06 2013 - 02:50:39 CEST