Re: rebuilding indexes - sure to cause a ruckus

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

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, December 10, 2003 5:44 AM

> 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).