Indexes

Verify that all indexes exist for the tables involved. In most implementations, the tables and corresponding indexes in the following list tend to be the most heavily used and should be separated across devices. In general, the following indexes should be on different physical devices from the tables on which they are created.

• S_ACCNT_POSTN

• S_OPTY

• S_ADDR_ORG

• S_OPTY_POSTN

• S_CONTACT

• S_POSTN_CON

• S_DOCK_TXN_LOG

• S_PARTY_RPT_RE

• S_SRV_REQ

• S_EVT_ACT

• S_OPTY

• S_ORG_EXT

For organizations that plan to use EIM extensively, you should put your key EIM tables (based on your unique business requirements) on different devices from the Siebel base tables, because all tables are accessed simultaneously during EIM operations.

You can speed up deletes and merges involving S_ORG_EXT by adding an index to one or more columns. For more information, see Siebel Performance Tuning Guide.