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 if you determine that an additional index would benefit your implementation. You cannot modify standard indexes, or delete them from the schema.

CAUTION:  Be careful when implementing custom indexes. Adding an index, while improving the performance of one query, might adversely affect others. It is strongly recommended that you consult Siebel Expert Services before implementing any custom indexes; it can assist you on evaluating the impact of creating such an index in your database.

Also, all changes should be thoroughly tested in your development environment before being introduced into production.

To create a custom index

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

For more information on index properties, see Siebel 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.

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

Bookshelf Home | Contents | Index | Search | PDF