Troubleshooting Siebel EIM Performance

Before troubleshooting performance issues that are specific to Siebel EIM, verify that there are no performance bottlenecks on the Siebel Server computer or on the network. This topic contains the following information:

• Optimizing SQL for Siebel EIM

• Using the USE INDEX HINTS and USE ESSENTIAL INDEX HINTS Parameters

• Using USE INDEX HINTS and USE ESSENTIAL INDEX HINTS: Example

• Using USE INDEX HINTS and USE ESSENTIAL INDEX HINTS: Criteria for Passing Indexes to the Database

• Using the SQLPROFILE Parameter

• Additional Indexes on Siebel EIM Tables

• Creating Proper Statistics on Siebel EIM Tables

• Dropping Indexes in Initial Runs of Siebel EIM

• Controlling the Size of Batches for Siebel EIM

• Controlling the Number of Records in Siebel EIM Tables

• Using the USING SYNONYMS Parameter with Siebel EIM

• Using the NUM_IFTABLE_LOAD_CUTOFF Extended Parameter with Siebel EIM

• Disabling Transaction Logging for Siebel EIM

• Disabling Database Triggers for Siebel EIM

• Running Siebel EIM Tasks in Parallel