Re: table fragment and index rebuild time

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Wed, 24 Jan 2007 13:16:30 +0100
Message-ID: <51p10hF1l7g6uU1@mid.individual.net>

On 24.01.2007 12:14, sybrandb wrote:
> On Jan 24, 11:47 am, "Steve Robin" <ocma..._at_gmail.com> wrote:

>> What you are talking about Tablespaces, but I am not. I am talking
>> about tables and indexes in ORACLE 9i.- Hide quoted text -- Show quoted text -

>
> I'm not talking about tablespaces only.
> Generally speaking regularly rebuilding tables and indexes is a waste
> of both human and computer resources.
> You would only need to rebuild something if that would *solve*
> something.
> Usually rebuilding doesn't resolve anything.
> The futility of rebuilding indexes has been discussed here many times.
> Please search the archives.

As a starting point:
http://www.miracleas.dk/images/upload/Docs/Richard%20Foote.pdf

        robert Received on Wed Jan 24 2007 - 06:16:30 CST