1. Object Types Reference
  2. Index

Index

An index creates a new index to improve performance of queries.

Caution: If you create a new index, then use caution. An index can decrease performance and use significant disk space.

This object type occurs in the following location in the object hierarchy:

  • Siebel Objects > Table > Index

The following table describes properties that Siebel CRM uses with an index.

Property Description

Alias (O)

Specifies the short name for the index.

Allow Reverse Scan (O)

If TRUE, then Siebel CRM creates the index with a backward page reference and a forward page reference. This configuration allows Siebel CRM to read the index backwards. The Allow Reverse Scan property applies only to a DB2 or a UDB database.

Based on Index

Specifies a replacement index. For example, assume the following occurs:

  1. A NAME index exists on the S_ORG_EXT table.

  2. A LOC index exists on the S_ORG_EXT_Un table.

  3. You enable CIAI (Case-Insensitive and Accent-insensitive).

  4. Siebel CRM creates new columns named NAME_CIAI and LOC_CIAI.

  5. You create an index named S_ORG_EXT_Un_C1 and set the Based on Index property of this index to S_ORG_EXT_Un.

  6. In this situation, the Application Object Manager uses S_ORG_EXT_Un_C1 instead of S_ORG_EXT_Un.

Cluster (O)

If TRUE, then Siebel CRM clusters the table on this index. For example, it physically saves the rows in the order that the index columns specify. The Cluster property applies only to a DB2 or a UDB database.

Cluster 2 (O)

If TRUE, then Siebel CRM appends this cluster key to all other indexes. The Cluster 2 property applies to the MSSQL server. It is applicable only to unique indexes.

Name (R)

Specifies the unique name.

Number of Unique Columns (S)

If Siebel CRM populates this property, then the value it populates equals the number of columns that participate in the uniqueness constraint.

Siebel CRM sets the Include Only property to TRUE for the columns that do not participate in the uniqueness constraint. In this situation, the number of columns in the index is more than the value that the Number of Unique Columns property contains.

The Number of Unique Columns property applies only to a DB2 or a UDB database. It is applicable only to unique indexes.

Partition Indicator

Specifies the partition that Siebel CRM uses with some databases to indicate where to place the index.

Target Platform

Specifies the platform that Siebel CRM uses with some databases to indicate the platform.

Type (O)

Specifies the index type.

Unique (O)

If TRUE, then this index is unique. A unique index prevents multiple rows that include the same values in each of the index columns.

User Name (R)

Specifies the user-friendly name for the index.

User Primary Key (O)

If TRUE, then EIM enforces uniqueness on this index. Siebel Enterprise Integration Manager (EIM) uses this property.