Rebuild Index recommendations

From: Sunit Patke <supatke_at_us.ibm.com>
Date: 1998/05/17
Message-ID: <355F745E.42A210DF@us.ibm.com>#1/1

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 Sun May 17 1998 - 00:00:00 CDT