Lables

Wednesday, 11 September 2013

Why use MultiLoad DELETE (versus SQL DELETE)?

MultiLoad DELETE is faster and uses less disk disk (no Transient Journal).
MultiLoad DELETE is restart able.
If SQL DELETE is aborted, Teradata applies Transient Journal rows.  SQL DELETE can be resubmitted, but starts from beginning.

2 comments: