MLOAD DELETE TASK vs SQL Statement DELETE

Tools & Utilities

MLOAD DELETE TASK vs SQL Statement DELETE

Using the following script to delete a large table, but it spent more time than SQL Delete Statement
.LOGTABLE TDATA.XXXX_TEST_LOGTABLE;
.RUN FILE logon;

.BEGIN DELETE MLOAD TABLES TDATA.XXXX_TEST
WORKTABLES TDATA.WT_XXXX_TEST
ERRORTABLES TDATA.UV_XXXX_TEST
;

.LAYOUT Layout1;
.FIELD PURGE_DT * CHAR(10);

DELETE FROM TDATA.XXXX_TEST
WHERE STRT_DT = :PURGE_DT ;

Can any help me to explain this situation ?

.IMPORT INFILE DATAIN FORMAT TEXT
LAYOUT Layout1;

.END MLOAD;

.LOGOFF;
1 REPLY
Enthusiast

Re: MLOAD DELETE TASK vs SQL Statement DELETE

Do you want to delete all the table or delete only the records from the file?