Re: Rebuild Index

From: Mohammed Ghouse <ghouse_at_mnsinc.com>
Date: 1998/04/02
Message-ID: <3523DD11.6B60BEE1@mnsinc.com>#1/1

Rebuilt is faster.
During rebuilding, the old index is not dropped. THe old index (instead of the table) is used to create the new index. So the application using the old index need not be stopped. Once the new index is created, the old index is dropped. This also means that you need to have enough space to hold both the indexes during the rebuild.

Mohammed Ghouse
Sr.Oracle Consultant
QAD Inc.

Vincent Birlouez wrote:

> Hi,
>
> I would like to rebuild some indexes (and keep the current storage
> parameters), there is two way (in Oracle 7.3) for doing that :
>
> 1. Drop the index
> Recreate the index
>
> 2. Rebuild the index (ALTER INDEX myindex REBUILD)
>
> Are those two ways rebuild the index in the same fashion or is there
> some differences ?
>
> Thanks !
Received on Thu Apr 02 1998 - 00:00:00 CST