Message-Id: <25998.339249@fatcity.com> From: "Gogala, Mladen" Date: Wed, 23 Jul 2003 16:09:36 -0400 Subject: RE: index rebuild This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C35156.570F6590 Content-Type: text/plain; charset="iso-8859-1" Oh yes, index rebuild will solve all your problems. sqlplus "/ as sysdba" rtfm immediate Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:mgogala@oxhp.com -----Original Message----- From: AK [mailto:oramagic@hotmail.com] Sent: Wednesday, July 23, 2003 2:15 PM To: Multiple recipients of list ORACLE-L 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_001_01C35156.570F6590 Content-Type: text/html; charset="iso-8859-1"

Oh yes, index rebuild will solve all your problems.

sqlplus "/ as sysdba"

rtfm immediate

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala@oxhp.com

-----Original Message-----
From: AK [mailto:oramagic@hotmail.com]
Sent: Wednesday, July 23, 2003 2:15 PM
To: Multiple recipients of list ORACLE-L
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