Skip to Content
0
Former Member
Feb 24, 2009 at 09:09 AM

Best way to updation of the 20 to 30 lakh records in database.

291 Views

Hi All,

Please suggest me in the below codes which is better ( in performance wise ) while updating the the 20 to 30 lach records at a time. ( let me know also which will won't go dump )

Assume I have 20 to 30 lakh records in my internal table.

1)

loop at it_itab into wa_itab.
insert z_tab from wa_itab.
endloop.

2)

insert z_tab from table it_itab.

Thanks in advance.