Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 18:58:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If the delete is as basic as you stated with:

no joins (sub queries included) or PI value restriction

I would use the MLOAD Delete option of Multiload.

It doesn't require input of any data just an SQL with the restriction on some column to qualify the delete. It does not require a journal or a commit, since Multiload keeps a logtable of where it left off. It is restartable and very, very fast.

It supports basic SQL except above restrictions.

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Benchmark Group
Certified Teradata Master
NCR Corp.

	<Prev	Next>		<<First	<Prev	Next>	Last>>