Siebel Server Sync Guide > Installing Siebel Server Sync for Microsoft Exchange Server >

Applying SSSE Index Files to the Database

A number of indexes are provided with Siebel CRM that are designed to enhance the performance of the PIMSI Dispatcher. Because these indexes are relevant only to SSSE, they are not included in the Siebel Repository by default. Instead, they are provided in an archive (SIF) file that must be imported into the repository, then applied to the physical database. This topic describes how to perform these tasks.

This task is an optional step in Roadmap for Installing SSSE.

To apply SSSE indexes to the database to improve PIMSI Dispatcher performance, perform the steps in the following procedure.

To apply SSSE index files to the database

1. In the Siebel Tools installation directory, navigate to the REPPATCH directory, for example, navigate to \Siebel\8.1\Tools_1\REPPATCH\.
2. Locate the following files:
   • SSSE_indexes_active_hor.sif (Siebel Cross-Industry Applications)
   • SSSE_indexes_active_sia.sif (Siebel Industry Applications)
3. Depending on the type of Siebel CRM application you have implemented, import either the SSSE_indexes_active_hor.sif file or the SSSE_indexes_active_sia.sif file into the Siebel Repository.

   For detailed information on importing SIF files to the Siebel Repository, see Using Siebel Tools.

4. After importing the SIF file, deploy the indexes by applying the database schema changes to the following database tables:
   • S_ACT_CONTACT
   • S_ACT_EMP
   • S_ADDR_ORG
   • S_ADDR_PER
   • S_CONTACT
   • S_CONTACT_BU
   • S_CONTACT_INFO
   • S_EVT_ACT
   • S_OPTY
   • S_ORG_EXT
   • S_PARTY
   • S_POSTN
   • S_POSTN_CON
   • S_PROJ
   • S_SRV_REQ
   • S_USER

     For detailed information on applying schema changes to the physical database, see the chapter on configuring tables in Configuring Siebel Business Applications.