Sunday, 8 January 2012

IBM Connections - A set of database indexes to improve the performance for the HOMEPAGE database which hosts Homepage, Search and News and Email Digest data.

Saw this via an email from one of our IBM Business Partners

The HOMEPAGE database is used to serve data to different applications likes Homepage, Search and News plus Email Digest data. For performance reasons we recommend to run the attached sql scripts to improve the existing databases indexes. In some cases the script will drop and re-create better indexes, in other cases the script will add new indexes. The technote is shipped with three SQL files depending on the database vendor being used.

The Technote includes SQL scripts for DB2 UDB, Oracle and SQL Server, and is available here: -

No comments: