Optimization techniques in EIM

Showing Answers 1 - 3 of 3 Answers


  • Feb 19th, 2006

1) Limit base tables and columns to be processed by using : only base Tables,ignore base Tables,only base Columns,ignore base Columns.

2) Always delete batches from EIM tables upon completion. Leaving old batches in the EIM table wastes space and can adversely affect performance. For other suggestions on working with batches.

3) Run independent EIM jobs in parallel. Two or more EIM processes can be started simultaneously by using the Siebel Server Manager.

4) Trace Flag Settings, using Synonyms, primary key only Parameters

Limiting the Number of Records and Rows for Merge Processes.

like this many techniques are there which will optimize the EIM process  

  Was this answer useful?  Yes


  • Jun 25th, 2006

Apart from that, you can use index.

Even using batch ranges ( eg. 100 to 200 ) will also increase the performance as it reduces the startup overheads.

  Was this answer useful?  Yes


  • Aug 20th, 2006

Hi, Even removing ( drop index) the index keys is also a crucial phenomenon here, because it reduces the additional work of EIM, and also we have to take care , the SQL trace flag is not set to 8 the job parameters of EIM srr job, for fast processing, or else it slows the processing as it saves a huge log file everytime, thk u Pavan

  Was this answer useful?  Yes


  • Jul 1st, 2010

Drop index only during initial loads.
Also you can remove Database Triggers for better performance.
Pls dont forget to create index and enable Database Triggers after the load is complete.


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions