Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: rebuilding indexes - sure to cause a ruckus

RE: rebuilding indexes - sure to cause a ruckus

From: Adams, Matthew (GECP, MABG, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Tue, 16 Dec 2003 07:54:27 -0800
Message-ID: <F001.005DA177.20031216075427@fatcity.com>


Content-Type: multipart/alternative;
 boundary="----_=_NextPart_001_01C3C3EC.5644451E" ------_=_NextPart_001_01C3C3EC.5644451E
Content-Type: text/plain;
 charset="iso-8859-1"

My brother (the NASA rocket scientist) usually says something like

' "Hey, this is all quite easy, it sure ain't raising kids"

Matt



Matt Adams - GE Appliances - matt.adams_at_appl.ge.com Their fundamental design flaws are completely hidden by their superficial design flaws.

-----Original Message-----
Sent: Wednesday, December 10, 2003 5:40 AM To: Multiple recipients of list ORACLE-L

Hi Yong,

One thing I should have mentioned when I posted my "epic" is that it not only attempts to correct the numerous technical errors in the article but also attempts to answer the various questions the article raises but totally fails to address. What I find most astonishing about the article is that the author confesses at the conclusion he has no idea when and why an index rebuild is beneficial. And as the author doesn't know, then surely it must all be so difficult, a "scientific-less phenomenon".

If I can convince anyone who makes it through my email that this isn't rocket science, then it's been worth the bandwidth.

BTW, does anyone know what a rocket scientist refers to when they say "Hey, this is all quite easy, it sure ain't ?????" ?

Cheers ;)

Richard

> Thanks, Richard. I'll read your long message more carefully later. I like
your
> statement that rebuilding an index or not is not rocket science. One needs
to
> measure the performance before and after the rebuild and make a conclusion
> himself. Many times we discuss performance issues and get very technical
and
> sophisticated, without showing experimental results! Having been a science
> researcher before, I'd like to emphasize that facts speak louder than
theories.
> There may be 10,000 24x7 databases in the world that don't easily allow
even
> testing an index rebuild. But there may be 100 times more production
databases
> in the world that are not 24x7. The individual DBA needs to do his control
> study and conclude, using experts' opinions as reference.
>
> Yong Huang
>
>
>
> __________________________________
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing.
> http://photos.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Yong Huang
> INET: yong321_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Foote
  INET: richard.foote_at_bigpond.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C3C3EC.5644451E
Content-Type: text/html;
 charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2655.35">
<TITLE>RE: rebuilding indexes - sure to cause a ruckus</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>My brother (the NASA rocket scientist) usually </FONT>
<BR><FONT SIZE=2>says something like </FONT>
</P>

<P><FONT SIZE=2>' &quot;Hey, this is all quite easy, it sure ain't raising kids&quot;</FONT>
</P>

<P><FONT SIZE=2>Matt</FONT>
</P>

<P><FONT SIZE=2>----</FONT>
<BR><FONT SIZE=2>Matt Adams - GE Appliances - matt.adams_at_appl.ge.com</FONT>
<BR><FONT SIZE=2>Their fundamental design flaws are completely</FONT>
<BR><FONT SIZE=2>hidden by their superficial design flaws.</FONT>
<BR><FONT SIZE=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - Douglas Adams</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Richard Foote [<A HREF="mailto:richard.foote_at_bigpond.com">mailto:richard.foote_at_bigpond.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, December 10, 2003 5:40 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Re: rebuilding indexes - sure to cause a ruckus</FONT>
</P>
<BR>

<P><FONT SIZE=2>Hi Yong,</FONT>
</P>

<P><FONT SIZE=2>One thing I should have mentioned when I posted my &quot;epic&quot; is that it not</FONT>
<BR><FONT SIZE=2>only attempts to correct the numerous technical errors in the article but</FONT>
<BR><FONT SIZE=2>also attempts to answer the various questions the article raises but totally</FONT>
<BR><FONT SIZE=2>fails to address. What I find most astonishing about the article is that the</FONT>
<BR><FONT SIZE=2>author confesses at the conclusion he has no idea when and why an index</FONT>
<BR><FONT SIZE=2>rebuild is beneficial. And as the author doesn't know, then surely it must</FONT>
<BR><FONT SIZE=2>all be so difficult, a &quot;scientific-less phenomenon&quot;.</FONT>
</P>

<P><FONT SIZE=2>If I can convince anyone who makes it through my email that this isn't</FONT>
<BR><FONT SIZE=2>rocket science, then it's been worth the bandwidth.</FONT>
</P>

<P><FONT SIZE=2>BTW, does anyone know what a rocket scientist refers to when they say &quot;Hey,</FONT>
<BR><FONT SIZE=2>this is all quite easy, it sure ain't ?????&quot; ?</FONT>
</P>

<P><FONT SIZE=2>Cheers ;)</FONT>
</P>

<P><FONT SIZE=2>Richard</FONT>
</P>

<P><FONT SIZE=2>----- Original Message -----</FONT>
<BR><FONT SIZE=2>To: &quot;Multiple recipients of list ORACLE-L&quot; &lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, December 10, 2003 5:44 AM</FONT>
</P>
<BR>

<P><FONT SIZE=2>&gt; Thanks, Richard. I'll read your long message more carefully later. I like</FONT>
<BR><FONT SIZE=2>your</FONT>
<BR><FONT SIZE=2>&gt; statement that rebuilding an index or not is not rocket science. One needs</FONT>
<BR><FONT SIZE=2>to</FONT>
<BR><FONT SIZE=2>&gt; measure the performance before and after the rebuild and make a conclusion</FONT>
<BR><FONT SIZE=2>&gt; himself. Many times we discuss performance issues and get very technical</FONT>
<BR><FONT SIZE=2>and</FONT>
<BR><FONT SIZE=2>&gt; sophisticated, without showing experimental results! Having been a science</FONT>
<BR><FONT SIZE=2>&gt; researcher before, I'd like to emphasize that facts speak louder than</FONT>
<BR><FONT SIZE=2>theories.</FONT>
<BR><FONT SIZE=2>&gt; There may be 10,000 24x7 databases in the world that don't easily allow</FONT>
<BR><FONT SIZE=2>even</FONT>
<BR><FONT SIZE=2>&gt; testing an index rebuild. But there may be 100 times more production</FONT>
<BR><FONT SIZE=2>databases</FONT>
<BR><FONT SIZE=2>&gt; in the world that are not 24x7. The individual DBA needs to do his control</FONT>
<BR><FONT SIZE=2>&gt; study and conclude, using experts' opinions as reference.</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt; Yong Huang</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt; __________________________________</FONT>
<BR><FONT SIZE=2>&gt; Do you Yahoo!?</FONT>
<BR><FONT SIZE=2>&gt; New Yahoo! Photos - easier uploading and sharing.</FONT>
<BR><FONT SIZE=2>&gt; http://photos.yahoo.com/</FONT>
<BR><FONT SIZE=2>&gt; --</FONT>
<BR><FONT SIZE=2>&gt; Please see the official ORACLE-L FAQ: http://www.orafaq.net</FONT>
<BR><FONT SIZE=2>&gt; --</FONT>
<BR><FONT SIZE=2>&gt; Author: Yong Huang</FONT>
<BR><FONT SIZE=2>&gt;&nbsp;&nbsp; INET: yong321_at_yahoo.com</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 http://www.fatcity.com</FONT>
<BR><FONT SIZE=2>&gt; San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and web hosting services</FONT>
<BR><FONT SIZE=2>&gt; ---------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt; To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>&gt; to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>&gt; the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt; (or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>&gt; also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
</P>
<BR>

<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.net</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Richard Foote</FONT>
<BR><FONT SIZE=2>&nbsp; INET: richard.foote_at_bigpond.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 http://www.fatcity.com</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and web hosting services</FONT>
<BR><FONT SIZE=2>---------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C3C3EC.5644451E--

------=_NextPartTM-000-99272c1a-1892-490c-ab6e-ffa8187bc020--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Adams, Matthew (GECP, MABG, 088130)
  INET: MATT.ADAMS_at_APPL.GE.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Dec 16 2003 - 09:54:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US