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@xxxxxxxxxxx> wrote: > > Hi, > Does any one has script to findout which indexes need to rebuild in > database > in single run? > > thanks > > > -- > //www.freelists.org/webpage/oracle-l > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l