We are using ODI version 12.2.1 to converge data from 4 databases into one. We run full load plan several times a day. Right after data is loaded, performance gets poor, if we gather stats on the affected tables using dbms_stats in the database, the performance returns back to normal.
Can ODI itself gather stats right after insert statements? If yes, please show me how to!
thank you help.