Archives of the TeradataForum
Message Posted: Wed, 29 Mar 2006 @ 19:24:42 GMT
| Subj: | | Re: MLOAD IMPORT TASK DELETE VS MLOAD DELETE TASK |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, March 29, 2006 14:08 -->
| | And considering the application phase only . Which is the faster task? IMPORT or DELETE. | |
| | this question born to purge dbc.acctg table while Resusage and ampusage are on. I want limitated the lock on this table during the delete
rows..... | |
MLOAD delete does not log to transient journal so it is faster than using BTEQ delete.
Regardless of what type of delete if you use PI then the delete is row level lock. It is less likely to have contention with other operation
on the system when using row level lock (PI operation) with the exception of operation that will required exclusive lock on the table such as
create index or some step in MLOAD IMPORT.
| 
