Hi gurus.
I am in charge of tunning a custom ABAP application, which runs as a job because it could take so much long time. There is a little excerpt that I am wondering how to improve. Is the following:
DO.
SELECT * FROM ztable UP TO 10000 ROWS.
DELETE ztable.
ENDSELECT.
IF sy-subrc NE 0.
EXIT.
ENDIF.
COMMIT WORK AND WAIT.
ENDDO.
ztable is a transparent custom table, likely with 20 million rows or more added in a week time. I understand that original programmer wanted to delete all the rows from this table but with 10,000 row packs instead all once and for all. I pressed F1 help for DELETE and read from ABAP keyword documentation: "The number of rows that can be deleted within a database LUW in the tables of a database has a specific restriction for each database, as each database system can only manage a limited amount of data in the rollback area, and a limited number of locks." I think the restriction of rows to be deleted was an important point to decide only delete with 10000 rows packs.
This program is old (1999), and my system is SAP ECC 6.0 with Oracle 11.2 as DBMS. Can this code excerpt be improved somehow? My try uses an internal table to avoid select-endselect and gets 100,000 instead 10000 rows. Do you think it is fine?:
DO.
SELECT * FROM ztable INTO it_ztable UP TO 100000 ROWS.
IF it_ztable[] is not initial.
DELETE ztable from it_ztable.
ELSE.
EXIT.
ENDIF.
COMMIT WORK AND WAIT.
ENDDO.
Thank you in advance for your advice!
Bluesky
