We are doing a TDTIM which prcessed about 300 sub-activities in 24 hours at step "start data transfer".
Only about 2 weeks of data was selected at package setting.
On both the control and receiver systems, there are more than 10 bg and dia processes all time busy, respectively.
I want to drop all indexes on the receiver side. However the duplicate data is a concern.
Is there other way to gain better performance?
BI701 with Oracle at UNIX.
Thanks!