Bookshelf Home | Contents | Index | PDF     

Siebel Server Sync Guide > Configuring Siebel Server Sync >

Configuring SSSE Indexes

Version 7.8 of SSSE provides certain database table indexes that are inactive by default to allow for optimum performance in Siebel implementations that do not include SSSE. For optimum performance of SSSE, itself, it is strongly recommended that you activate and use these indexes. This is a task in Process of Configuring the Database for Optimum SSSE Performance.

For a list of the indexes to configure and the database tables that contain them, see Table 12. The DB_LAST_UPD field has been added to each of the listed tables specifically for SSSE.

Table 12. Database Tables and Indexes that Affect SSSE Performance
Table
Index

S_ACT_CONTACT

S_ACT_CONTACT_M1(DB_LAST_UPD,ACTIVITY_ID)

S_ACT_EMP

S_ACT_EMP_M5(DB_LAST_UPD,ACTIVITY_ID)

S_ADDR_ORG

S_ADDR_ORG_M7(DB_LAST_UPD,ROW_ID)

S_ADDR_PER

S_ADDR_PER_M6(DB_LAST_UPD,ROW_ID)

S_CONTACT

S_CONTACT_M23(DB_LAST_UPD,PAR_ROW_ID)

S_CONTACT_BU

S_CONTACT_BU_M3(DB_LAST_UPD,CONTACT_ID)

S_CONTACT_INFO

S_CONTACT_INFO_M1(DB_LAST_UPD, SYNC_FLG,TARGET_PER_ID)

S_EVT_ACT

S_EVT_ACT_M12(DB_LAST_UPD,ROW_ID

S_OPTY

S_OPTY_M10(DB_LAST_UPD,ROW_ID)

S_ORG_EXT

S_ORG_EXT_M23(DB_LAST_UPD,PAR_ROW_ID)

S_PARTY

S_PARTY_M5(DB_LAST_UPD,ROW_ID)

S_POSTN

S_POSTN_M4(DB_LAST_UPD,PAR_ROW_ID)

S_POSTN_CON

S_POSTN_CON_M4(DB_LAST_UPD,CON_ID)

S_PROJ

S_PROJ_M9(DB_LAST_UPD,ROW_ID)

S_SRV_REQ

S_SRV_REQ_M12(DB_LAST_UPD,ROW_ID)

S_USER

S_USER_M3(DB_LAST_UPD,ROW_ID)

To activate the SSSE indexes, you must apply one of the following files, located in the Siebel Tools Client \REPPATCH installation directory, from within Siebel Tools:

  • SSSE_indexes_active_hor.sif (for Siebel Business Applications (HOR) installations)
  • SSSE_indexes_active_SIA.sif (for Siebel Industry Application (SIA) installations)

The following procedure describes how to activate the SSSE indexes.

To activate and use SSSE Indexes

  1. Log in to Siebel Tools, version 7.8, connecting to the Server database.
  2. Lock the following projects:
    • Table Activity
    • Table Employee
    • Table Opty
    • Table Organization
    • Table Party
    • Table Person
    • Table Project
    • Table Service Request
  3. From the Tools menu, select Import from Archive.
  4. Navigate to the \Siebel Tools Client \REPPATCH\ directory and select the SSSE_indexes_active_xxx.sif file that is appropriate for your environment.

    The Import Wizard dialog box is displayed.

  5. For the Conflict Resolution option, select Overwrite the object definition in the repository. Click Next.
  6. When the Conflicting Objects list box is displayed, click Next without making any changes.
  7. In the Summary message box, click Yes, then click Finish.
  8. In the Siebel Tools Object Explorer list, select Table.
  9. Query for all of the tables that are listed in Table 12, select the current query result, and apply the changes to the database.

    For detailed information on applying changes to the database, see Configuring Siebel Business Applications.

    If your query result omits any of the required tables, select each omitted table individually and apply it.

  10. Migrate the repository changes to the test and production environments.

    For further information on this task, see Developing and Deploying Siebel Business Applications.

    
Siebel Server Sync Guide