Re: Rebuild Index

From: Naren Chintala <naren_at_att.com>
Date: 1998/03/27
Message-ID: <351BEE69.3609@att.com>#1/1

Method 2

---

The existing index is not dropped until the new index is created. The select queries will use the index. This is not the case when you drop and recreate the index (method 1).

HTH 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 Fri Mar 27 1998 - 00:00:00 CST