Re: WHEN TO REBUILD

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 8 Jun 2005 18:20:57 +0100
Message-ID: <bf463805060810201485bdaf@mail.gmail.com>

In general, rebuilding indexes is not necessary. There are of course special cases.
Please see:

http://miracleas.dk/images/upload/Docs/Richard%20Foote.pdf
http://www.dizwell.com/html/voodoo_tuning.html
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2913600659112
http://www.jlcomp.demon.co.uk/circular.html

It will take some time to digest all this, but you will be more than compensated by
the time you don't waste on rebuilding indexes.

HTH Jared

On 6/8/05, Seema Singh <oracledbam_at_hotmail.com> wrote:
>
> Hi,
> Does any one has script to findout which indexes need to rebuild in
> database
> in single run?
>
> thanks
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 08 2005 - 13:25:58 CDT