Re: When should one rebuild an index?

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 28 Dec 2008 14:05:48 -0800
Message-ID: <1230501947.867613@bubbleator.drizzle.com>

Date: Sun, 28 Dec 2008 14:05:48 -0800
From: DA Morgan <damorgan_at_psoug.org>
Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 2.0.0.18 (Windows/20081105) MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server Subject: Re: When should one rebuild an index? References: <3bddc9d2-d04f-4525-9703-9c74ccd33d9e_at_h20g2000yqn.googlegroups.com> <%Mg5l.3876$jZ1.88_at_flpi144.ffdc.sbc.com> <1230357209.294829_at_bubbleator.drizzle.com> <oYs5l.10821$yr3.9829_at_nlpi068.nbdc.sbc.com> <1230405015.761378_at_bubbleator.drizzle.com> <emy5l.15203$Ws1.6015_at_nlpi064.nbdc.sbc.com> <6rnsdcF2i5bnU1_at_mid.individual.net> <XOA5l.9804$as4.1739_at_nlpi069.nbdc.sbc.com> <6rp8o6F2mq81U1_at_mid.individual.net> <kTO5l.15267$Ws1.6608_at_nlpi064.nbdc.sbc.com> In-Reply-To: <kTO5l.15267$Ws1.6608_at_nlpi064.nbdc.sbc.com>

Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <1230501947.867613_at_bubbleator.drizzle.com>

Cache-Post-Path: bubbleator.drizzle.com!unknown_at_dsl-216-162-218-178.drizzle.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 28
X-Complaints-To: abuse_at_csolutions.net
Xref: textnews.cambrium.nl comp.databases.oracle.server:82465

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.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Dec 28 2008 - 16:05:48 CST