> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> 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.
