Re: Rebuild Index recommendations

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Fri, 22 May 1998 19:15:48 GMT
Message-ID: <01bd85c6$1ec09bc0$a504fa80@mndnet>

The reason to rebuild index is to coalesce the free space into a contiguous disk space. The best way to do this is to set the parameter pctincrease to 1 for the TABLESPACE in question or for that matter all tablespaces except Oracle related tablespaces such as SYSTEM, ROLLBACKS, TOOLS etc.

If you do this, SMON coalesces the free space. Some times it takes upto about 10 minutes to do it but it does it automatically.

suresh.bhat_at_mitchell-energy.com

Sunit Patke <supatke_at_us.ibm.com> wrote in article <355F745E.42A210DF_at_us.ibm.com>...
> Do any of you REBUILD or DROP and CREATE your application indexes? If
> yes what factors do you consider when deciding when to reorg an index
> (and tables for that matter).
>
>
> Thanks
>
> Sunit Patke
>
>
Received on Fri May 22 1998 - 14:15:48 CDT