Re: When should one rebuild an index?

From: Bob Jones <email_at_me.not>
Date: Tue, 30 Dec 2008 22:02:54 -0600
Message-ID: <P9C6l.7726$hc1.6765@flpi150.ffdc.sbc.com>

"Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message news:gjdboq$ivs$9_at_solani.org...
> On Sun, 28 Dec 2008 18:08:46 -0600, Bob Jones wrote:
>
>
>> Index structure and space usage are meaningless in determining index
>> rebuild? So in your opinion what is meaningful?
>
> Nothing. Indexes do not need to be rebuilt on regular basis, period.
> Please, read this:
> http://www.oracle.com/global/nl/education/specials/pdfs/0806_richard.pdf
>

Who said they need to be rebuilt regularly? Please read this thread first. Received on Tue Dec 30 2008 - 22:02:54 CST

Original text of this message