Configuring Siebel eBusiness Applications > Configuring Tables and Columns >

About Indexes and Index Columns

An index object definition is a logical representations of physical index in the underlying database management system. Siebel applications include a set of standard indexes and are named with a prefix of S_.

You cannot modify or delete standard indexes; however, if an index would benefit your implementation, you can create custom indexes.

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.

About Index Column Object Type

Index Column is a child object type of the Index object. An Index Column object definition associates one column to the index that is the parent object definition of the index column.

The Index Column object type has the following important properties:

• Column Name. The name of the column object definition to include in this index object definition.
• Sequence. The integer value that indicates the order of the column in the index relative to other columns. The Sequence property must be populated even when only one column is present.
• Sort Order. The sort order for the index column. Its value can be either Asc (ascending) or Desc (descending).