Configuring Siebel eBusiness Applications > Configuring Tables and Columns >

Creating Custom Indexes

You can create custom indexes to enhance the performance of your implementation. You cannot modify standard indexes or delete them from the schema.

When implementing custom indexes, consider the following:

• Typically, new tables require new indexes. Use caution when creating indexes. Custom indexes can cause the standard indexes to not be used and can adversely impact performance.
• If at some point you no longer require a custom index that you have created, do not delete it from the Siebel repository. Instead, inactivate it by selecting the object's Inactive property check box in the Object List Editor.
• Any custom indexes should be thoroughly tested in a test environment before being introduced into production.
• Do not define indexes with names longer than 18 characters in the DB2 environments.

To create a custom index

1. Connect to your local development database with Siebel Tools.
2. In the Object Explorer, expand the Table object type.
3. In the Object List Editor, select the table to which you want to add an index.
4. In the Object Explorer, expand the Index object type.
5. Select Edit > New Record to add a custom index.

   For more information on index properties, see Object Types Reference.

   Do not use index names that are reserved words on your server or client database.

   When you add custom indexes to tables, Siebel Tools appends an _X to the index name.

6. In the Object Explorer, select the Index Column object type.
7. Select Edit > New Record to specify each column to add to the index.