RE: Rebuilding Indexes Question

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 22 Oct 2001 16:07:09 -0700
Message-ID: <F001.003B1C76.20011022155018@fatcity.com>

> -----Original Message-----
> From: cjordan_at_smcwv.com [mailto:cjordan_at_smcwv.com]
>
> What are the advantages/disadvantages to doing a alter index rebuild
> (Oracle 8.0.X) versus dropping and recreating the index.

My personal opinion - if your database is not subject to any of the bugs reported against alter index ... rebuild commands,

{some bug examples:

[BUG:1475310] ALTER INDEX .. REBUILD ONLINE/ MOVE IOT ONLINE can corrupt the index. See [NOTE:125149.1]
[BUG:1427002] ALTER INDEX i REBUILD PARAMETERS('SYNC') may raise ORA-29863 / DRG-10595 / ORA-28579 (interMedia Text)
[BUG:1573283] OERI:6033 from ALTER INDEX .. REBUILD ONLINE PARAMETERS ('OPTIMIZE FULL')

etc...
}

alter index ... rebuild is easier to use, since you don't have to specify the full syntax that was used to build the index. I don't know of any reasons to prefer the drop index / create index method.

Any corrections/suggestions welcome. Received on Mon Oct 22 2001 - 18:07:09 CDT