Message-Id: <25998.339251@fatcity.com> From: "AK" Date: Wed, 23 Jul 2003 13:12:08 -0700 Subject: Re: index rebuild This is a multi-part message in MIME format. ------=_NextPart_000_06EE_01C3511C.04F7AAE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The only reason I wanted to build the indexes was to relocate them to = another tablespace ( LMT ) so that I can get rid of high fragmentation = and start living . -ak ----- Original Message -----=20 From: Tanel Poder=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, July 23, 2003 11:49 AM Subject: Re: index rebuild Hi! For index, yes, if you use: alter index rebuild compute = statistics; But don't rebuild your indexes daily, it's an expensive operation... = and you won't gain much from it anyway. Tanel. ----- Original Message -----=20 From: AK=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, July 23, 2003 9:14 PM Subject: index rebuild Does index rebuild generates new statistics as well ? How does that = can hit performance intermediately if I want to rebuild few indexes = daily just to finish everything in 5 days . -ak ------=_NextPart_000_06EE_01C3511C.04F7AAE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
The only reason I wanted to build the = indexes was=20 to relocate them to another tablespace ( LMT ) so that I can get rid of = high=20 fragmentation and start living .
 
-ak
 
----- Original Message -----
From:=20 Tanel=20 Poder
To: Multiple recipients of list = ORACLE-L=20
Sent: Wednesday, July 23, 2003 = 11:49=20 AM
Subject: Re: index = rebuild

Hi!
 
For index, yes, if you use: alter = index=20 <name> rebuild compute statistics;
 
But don't rebuild your indexes daily, = it's an=20 expensive operation... and you won't gain much from it = anyway.
 
Tanel.
----- Original Message -----
From:=20 AK=20
Sent: Wednesday, July 23, = 2003 9:14=20 PM
Subject: index rebuild

Does index rebuild generates new = statistics as=20 well ? How does that can hit performance intermediately if I want to = rebuild=20 few indexes daily just to finish everything in 5 days .