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

Home -> Community -> Usenet -> c.d.o.server -> Re: Proving or Debunking the need for rebuilding

Re: Proving or Debunking the need for rebuilding

From: joel garry <joel-garry_at_home.com>
Date: 9 Nov 2006 16:00:47 -0800
Message-ID: <1163116847.811419.161170@k70g2000cwa.googlegroups.com>

Ben wrote:
> 9.2.0.5 EE AIX5L
>
> Ok so I do believe everyone when they say to quit rebuilding indexes,
> except for certain special cases ( like large purges on tables that
> will never grow again unless the moon is full and the wind blows
> eastward). I do understand that rebuilds can be harmful, BUT how do I
> prove one way or the other?
>
> I want to create matrices on the before and after of an index rebuild.
> How? I don't want to blindly say, "Yes this index needs to be rebuilt"
> I want to show the performance gain or loss from a rebuild. Surely
> there is a way to do this. Do you simply anayze ... validate and
> capture the statistics on the indexes?
>
> Thanks for any ideas and help.

Don't know if it is mentioned in the previous posts, but see the classic http://www.miracleas.dk/images/upload/Docs/Richard%20Foote.pdf

jg

--
@home.com is bogus.
http://www.taborcommunications.com/dsstar/00/0201/101280.html
Received on Thu Nov 09 2006 - 18:00:47 CST

Original text of this message

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