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
|
|
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
- Log in to Siebel Tools, version 7.8, connecting to the Server database.
- Lock the following projects:
- Table Activity
- Table Employee
- Table Opty
- Table Organization
- Table Party
- Table Person
- Table Project
- Table Service Request
- From the Tools menu, select Import from Archive.
- 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.
- For the Conflict Resolution option, select Overwrite the object definition in the repository. Click Next.
- When the Conflicting Objects list box is displayed, click Next without making any changes.
- In the Summary message box, click Yes, then click Finish.
- In the Siebel Tools Object Explorer list, select Table.
- 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.
- Migrate the repository changes to the test and production environments.
For further information on this task, see Developing and Deploying Siebel Business Applications.
|