I am working on a performance tuning of an extract that runs for 7 hrs. Well, I got it down to 1 hour but noticing the data differences (Telephone numbers). And when I debugged the old and new, noticed the sort statement behaves differently. Both programs use the same sort statement.
SORT t_adr2 BY addrnumber date_from.
One sorts in the order
and other sorts
The program reads the first telephone number that it gets after sorting.
Read itab index 1.
Because the sort order is different I am getting different values from old and new programs. Any feedback will be appeciated.
P.S - When I run both the programs for just one customer, I don't run into this issue. Both the programs return me the same values. But they are different when I run the program wide open.