Bookshelf Home | Contents | Index | Search | PDF

Siebel Tools Reference > Adding Custom Extensions to the Data Model > Updating the Logical Schema Definition in the Local Environment >

Adding Custom Indexes

---

You can create custom indexes to enhance the performance of your implementation.

NOTE:  You cannot modify standard indexes, or delete them from the schema.

When implementing custom indexes, consider the following:

• While adding an index may improve the performance of one query, it might adversely affect the performance of others. It is strongly recommended that you consult Siebel Expert Services to help evaluate the potential impact of a custom index in your database.
• 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.

  Deleting the custom index from the repository would remove the record from the logical schema but not from the physical schema. This would result in the logical and physical schemas being out of sync.

• Any custom indexes should be thoroughly tested in a test environment before being introduced into production.

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 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.

Bookshelf Home | Contents | Index | Search | PDF