Re: index rebuild

From: AK <oramagic_at_hotmail.com>
Date: Wed, 23 Jul 2003 13:12:08 -0700
Message-Id: <25998.339251@fatcity.com>

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 <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_06EE_01C3511C.04F7AAE0 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.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>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 .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>-ak</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></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=3Dtanel.poder.003_at_mail.ee =
href=3D"mailto:tanel.poder.003_at_mail.ee">Tanel=20   Poder</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 = 11:49=20
  AM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: index =

rebuild</DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=3DArial size=3D2>Hi!</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>For index, yes, if you use: alter =

index=20
<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>&nbsp;</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>=20

</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=20 Received on Wed Jul 23 2003 - 15:12:08 CDT