Properties of an Index of a Siebel Table

The following table describes some of the properties that Siebel CRM commonly uses with an index.

Property	Description
Name	Stores the name of the database index.
Unique	TRUE indicates that Siebel CRM does not allow multiple rows with the same value. You must not define a custom unique index without assistance. For more information, see Getting Help From Oracle.
Type	Indicates the type of index. Siebel CRM commonly uses the following types: Primary Key. An index that Siebel CRM indexes on the ROW_ID column. User Key. A custom index that you define. You specify the set of index columns. It must consist of a unique combination of columns. Extension. An extension index that Siebel Tools creates by default if you add an index. Siebel CRM specifies the set of index columns. System. A predefined index. You must not modify a predefined index.

Property

Description

Name

Stores the name of the database index.

Unique

TRUE indicates that Siebel CRM does not allow multiple rows with the same value.

You must not define a custom unique index without assistance. For more information, see Getting Help From Oracle.

Type

Indicates the type of index. Siebel CRM commonly uses the following types:

Primary Key. An index that Siebel CRM indexes on the ROW_ID column.
User Key. A custom index that you define. You specify the set of index columns. It must consist of a unique combination of columns.
Extension. An extension index that Siebel Tools creates by default if you add an index. Siebel CRM specifies the set of index columns.
System. A predefined index. You must not modify a predefined index.