Re: drop/recreate index

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 8 Jan 2007 12:37:59 -0800
Message-ID: <1168288678.950672.155770@38g2000cwa.googlegroups.com>

astalavista wrote:
> Hi,
>
> What is the difference ( about block allocation)
> between rebuild index and drop/create index ?
>
> Thanks for your help

Rebuild index is the more generally preferred alternative these days.

It requires twice as much storage potentially as the drop and create approach since you "still have" the blocks for the existing index until oracle is all done "cloning/rebuilding" the existing index structure.

However, dropping of indexes is often done for batch cycles etc to speed up dataloads of large tables.

Is there something specific you are looking at in your environment that you want to supply some more details on? Received on Mon Jan 08 2007 - 14:37:59 CST