how to avoid embedded loops?
I am not an expert and dealing with a performance issue. When a debugged the code I figured that a embedded loop was causing the performance issue and I am looking for analternative way to write that piece of the code.
The code is:
loop at SOURCE_PACKAGE assigning <source_fields>.
loop at i_t_d032 into i_l_d032 where
/bic/zfield1 = <source_fields>-/bic/zfield1 and
/bic/zfield2 = <source_fields>-/bic/zfield2 and
/bic/zfield3 = <source_fields>-/bic/zfield3 and
/bic/zfield4 <= <source_fields>-/bic/zfield4 .
FYI - I_t_d032 has 30 million records.
I apprciate your help.