|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/11/2008 5:27:24 AM
Posts: 2,
Visits: 8
|
|
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;
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 7/12/2008 11:43:32 AM
Posts: 12,
Visits: 44
|
|
Do you want to delete all the table or delete only the records from the file?
In BI, the 90% of the work comes from the 10% of the records.
|
|
|
|