Oracle Siebel CRM 8 Developer's Handbook

Creating custom indexes

The following procedure describes how to create a custom index definition to support faster queries and sorting operations on one or more custom columns:

1. Navigate to the S_ORG_EXT table.
2. Check out or lock the table if necessary.
3. In the Object Explorer, expand the Table type and select the Index type.
4. In the Indexes list create a new record.
5. Set the Name to S_ORG_EXT_AHA1.

   Note

   A suffix of _X will be added automatically.

6. In the Object Explorer, expand the Index type and select the Index Column type.
7. In the Index Columns list, create a new record with the following values:
   • Column Name: X_AHA_EXT_1
   • Sequence: 1
   • Sort Order: Asc
8. Compile the S_ORG_EXT table.
9. Apply the database changes (see upcoming section).

A Siebel Tools archive file (S_ORG_EXT.sif ...