Data load takes long time in DSO when look up dso changes to write optimized type
We have a delta load from DSO 1 to DSO2 picking 30k records .It has end routine which does a look up on standard DSO (say DSO3).having 26 million records
The load DSO 1 to DSO2 takes few minutes to finish .But after changing the look up DSO3 to write optimized type, the load from DSO1 to DSO2 taking more than 2 hours .
Can you please suggest why it takes much take after changing the dso type.
We changed to write optimized because standard dso takes long time for activation step.,