Re: How to find out if my index is optimal or scattered

From: Jared Still <>
Date: Mon, 28 Sep 2009 10:45:09 -0700
Message-ID: <>

Well said Robert.
There are times when an index rebuild is a good idea.

Rebuilding of indexes has been so abused that we are quick to say 'You don't need to do that'.

There are times though when it may be required.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: Home Page:

On Tue, Sep 15, 2009 at 11:02 AM, Robert Freeman <>wrote:

> Hmmmm... I know we are all just itching to jump on someone should they
> mention index rebuilds... but, it sounds to me like the OP might well be
> talking about a case where there is a PK index with sparse deletions. If you
> look in the AskTom thread listed by Paul, this is actually a case where
> index rebuilds MIGHT (MIGHT) be worth considering. Of course, I'd be asking
> lots of questions and making sure that there are not some application
> related things we could be doing differently, etc...etc...
> It makes me wonder though, are we becomming like those in the past, when we
> discount every rebuild index question (and similiar questions) without a
> second thought because we have our standard answers. Are we starting to
> respond with a scoff and a get away from me kid your bothering me attitude?
> How can we always be so sure that our answers are the right ones, if we
> don't know and have not asked, all the questions? When things change (and
> things always change) if we ignore the questions we think we have the
> answers too how do we find out that we are actually wrong becuase of change?
> Just a few thoughts.....
> Robert G. Freeman
> Oracle ACE
> Author:
> Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY
> OCP: Oracle Database 11g Administrator Certified Professional Study Guide
> (Sybex)
> Oracle Database 11g New Features (Oracle Press)
> Portable DBA: Oracle (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Oracle9i RMAN Backup and Recovery (Oracle Press)
> Oracle9i New Features (Oracle Press)
> Other various titles out of print now...
> Blog:
> The LDS Church is looking for DBA's. You do have to be a Church member in
> good standing. A lot of kind people write me, concerned I may be breaking
> the law by saying you have to be a Church member. It's legal I promise! :-)

Received on Mon Sep 28 2009 - 12:45:09 CDT

Original text of this message