Re: Rebuild Index recommendations

From: Venkat <vreddy_at_ix.netcom.com>
Date: Mon, 18 May 1998 10:14:48 -0400
Message-ID: <6jpfp2$jlj@dfw-ixnews8.ix.netcom.com>

ANALYZE your indexes (VALIDATE STRUCTURE optional) and look at the INDEX_STATS table. It is a fixed table - meaning only the results of the last ANALYZE are stored in the table. Then look at lf_rows and del_lf_rows columns of INDEX_STATS. If del_lf_rows is about 25-30% of lf_rows it's time to do a rebuild. del_lf_rows indicates the rows that have been deleted.

HTH
Venkat

>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).
>
>Our application went into production many months ago and the database
>has never been reorganized. The application is an OLTP application and
>there is heavy insert/update activity on some of the main tables. Also
>our application updates keys of certain indices on a regular basis.
>
>Any help will be appreciated.
>
>Thanks
>
>Sunit Patke
>
Received on Mon May 18 1998 - 09:14:48 CDT