Bookshelf Home | Contents | Index | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Customizing a Development Environment > Siebel Tools Considerations on DB2 UDB for z/OS and OS/390 > Inactivating Unused IndexesThe standard Siebel data model has a large number of indexes that can degrade performance on DB2 UDB for z/OS and OS/390. This is because DB2, unlike Oracle and Microsoft SQL Server, stores Where those related tables are not used, DB2 has the indexes for those foreign keys with one entry: CAUTION: Before deleting indexes, back up your Siebel Repository and the original storage control and schema.sql files that you installed. Keep track of the indexes you delete. If you notice performance degradation after deleting indexes, review your work and restore the repository, storage control file, and schema.sql. If you need help, contact Siebel Technical Support. |
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 |