Re: When should one rebuild an index?

From: Bob Jones <email_at_me.not>
Date: Sun, 28 Dec 2008 18:08:46 -0600
Message-ID: <byU5l.3984$jZ1.2573@flpi144.ffdc.sbc.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1230501947.867613_at_bubbleator.drizzle.com...
> Bob Jones wrote:

>> "Robert Klemme" <shortcutter_at_googlemail.com> wrote in message 
>> news:6rp8o6F2mq81U1_at_mid.individual.net...
>>> On 28.12.2008 02:41, Bob Jones wrote:
>>>
>>>> I don't know what your definition of "meaningless" is here. How could 
>>>> something be "meaningless" yet provides a specific piece of 
>>>> information.
>>> It provides a bit of data, whether that is information depends on the 
>>> usefulness.  If you cannot do anything with it, it's just data.
>>>
>>> http://en.wikipedia.org/wiki/Data#Meaning_of_data.2C_information_and_knowledge
>>>
>>
>> Hmmm, so it provides meaningless data about index structures and space 
>> usage. I  wonder why Oracle went through all that trouble.
>

> Not meaningless with respect to index structures and space usage.
> Meaningless within the context of the topic being discussed. Meaningless
> as a criteria for rebuilding indexes. Not everything that is not white
> is black. There are shades of gray and a rainbow's worth of colors in
> between.

Index structure and space usage are meaningless in determining index rebuild? So in your opinion what is meaningful? Received on Sun Dec 28 2008 - 18:08:46 CST

Original text of this message