Bookshelf Home | Contents | Index | Search | PDF

Siebel Tools Reference > Data Objects Layer >

Indexes

---

An Index object definition is the direct representation of a database index in a DBMS.

Siebel applications include a set of standard indexes. All indexes supplied by Siebel have the S_ prefix.

NOTE:  You cannot modify or delete standard indexes.

You can create custom indexes if you determine that an additional index would benefit your implementation.

The Index object type has the following key properties:

• Name. The name of the database index.
• Unique. A TRUE or FALSE value indicating whether multiple rows with the same value are allowed.
• Type. Indicates which of the following styles describes the index:
  • Primary Key value. A primary key index is indexed on the ROW_ID column.
  • User Key value. A user key index is developer-created. The set of index columns is developer-specified. It must consist of a unique combination of columns.
  • Extension value. An extension index is created by default when the developer adds an index. The set of index columns is system-specified.
  • System value. System indexes are included in standard Siebel applications, and you cannot modify them.

NOTE:  You can use Siebel Tools to create indexes in ascending or descending order. For Oracle, all indexes will be created in 'asc' mode (even if defined as 'desc' in Tools) since only the Rule Based Optimizer (RBO) is currently supported by the Siebel application for Oracle databases.

Bookshelf Home | Contents | Index | Search | PDF