Re: index rebuild

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Wed, 23 Jul 2003 20:50:16 +0300
Message-Id: <25998.339204@fatcity.com>

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 <name> 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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>For index, yes, if you use: alter index =

<name> rebuild compute statistics;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>But don't rebuild your indexes daily, =
it's an=20
expensive operation... and you won't gain much from it = anyway.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Tanel.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A title=3Doramagic_at_hotmail.com =
href=3D"mailto:oramagic_at_hotmail.com">AK</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = title=3DORACLE-L_at_fatcity.com=20
  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, July 23, 2003 = 9:14=20
  PM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> index rebuild</DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=3DArial size=3D2>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 .</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial =
size=3D2>-ak</FONT></DIV></BLOCKQUOTE></BODY></HTML> Received on Wed Jul 23 2003 - 12:50:16 CDT