From ahillman@erols.com Sat, 27 Oct 2001 16:33:08 -0700
From: "Alex Hillman" <ahillman@erols.com>
Date: Sat, 27 Oct 2001 16:33:08 -0700
Subject: RE: Rebuilding Indexes Question
Message-ID: <F001.003B66FC.20011027163017@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: RE: Rebuilding Indexes Question



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@fatcity.com 
  [mailto:root@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@smcwv.com [<A 
  href="">mailto:cjordan@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.