I
remember reading somewhere that alter index ... rebuild analyzes index with
estimate default. In case this is not desirable one need to reanalyze an index
after rebuilding.
<SPAN
class=736382823-27102001>
Alex
Hillman
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">
<FONT face="Times New Roman"
size=2>-----Original Message-----From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of Jacques KilchoerSent:
Monday, October 22, 2001 7:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Rebuilding Indexes
Question
> -----Original Message----- >
From: cjordan_at_smcwv.com [<A
href="">mailto:cjordan_at_smcwv.com] <FONT
size=2>> > 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') <FONT
size=2>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 Sat Oct 27 2001 - 18:33:08 CDT
