RE: index rebuild

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Wed, 23 Jul 2003 16:09:36 -0400
Message-Id: <25998.339249@fatcity.com>

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_at_oxhp.com

-----Original Message-----
From: AK [mailto:oramagic_at_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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.3502.4856" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=585410720-23072003>Oh
yes, index rebuild will solve all your problems.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=585410720-23072003>sqlplus "/ as sysdba"</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=585410720-23072003>rtfm
immediate</SPAN></FONT></DIV>
<DIV> </DIV>
<P><FONT face=Arial size=2>Mladen Gogala</FONT> <BR><FONT face=Arial
size=2>Oracle DBA</FONT> <BR><FONT face=Arial size=2>Phone:(203) 459-6855</FONT>
<BR><FONT face=Arial size=2>Email:mgogala_at_oxhp.com</FONT> </P>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> AK [mailto:oramagic_at_hotmail.com]<BR><B>Sent:</B> Wednesday, July 23, 2003 2:15 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> index rebuild<BR><BR></DIV></FONT>
<DIV><FONT face=Arial size=2>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 .</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>-ak</FONT></DIV></BLOCKQUOTE></BODY></HTML> Received on Wed Jul 23 2003 - 15:09:36 CDT