Message-Id: <25998.339204@fatcity.com> From: "Tanel Poder" Date: Wed, 23 Jul 2003 20:50:16 +0300 Subject: Re: index rebuild This is a multi-part message in MIME format. ------=_NextPart_000_04BB_01C3515C.05896F80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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_04BB_01C3515C.05896F80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi!

For index, yes, if you use: alter index = <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
To: Multiple recipients of list = ORACLE-L=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 .

-ak