Siebel Performance Tuning Guide > Tuning Siebel EIM >

Troubleshooting Siebel EIM Performance

Before troubleshooting Siebel EIM performance, verify that there are no performance bottlenecks on the Siebel Server computer or 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 the Docking: Transaction Logging Parameter for Siebel EIM
• Disabling Database Triggers for Siebel EIM
• Running Siebel EIM Tasks in Parallel