2007 Oct 25 11:32 PM
Dear Friends,
Our Backorder rescheduling job runs in background every day at 2AM using program SDV03V02. Currently it is taking more than 7 hours. Need to do performance tuning ASAP. Tried to achieve by applying indexes, OSS notes 0000822884. But there is only 15min improvement after applying these.
Since this is frequently used batch job in every project. Please through some light if you come across this situation. Your immediate reply is appreciated and thanks in advance.
-Rama
2007 Oct 25 11:39 PM
Dear Friends,
Our Backorder rescheduling job runs in background every day at 2AM using program SDV03V02. Currently it is taking more than 7 hours. Need to do performance tuning ASAP. Tried to achieve by applying indexes, OSS notes 0000822884. But there is only 15min improvement after applying these.
Since this is frequently used batch job in every project. Please through some light if you come across this situation. Your immediate reply is appreciated and thanks in advance.
-Rama
2007 Oct 25 11:39 PM
2007 Oct 25 11:43 PM
2007 Oct 26 2:01 PM
What about notes 438325, 856055, 969018, 822884 or 90230?
Rob