Archives of the TeradataForum

Message Posted: Mon, 25 Sep 2001 @ 01:23:19 GMT

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

Tom, Absolute best recommendation, but just to be clear for the list.

There are two delete functions in Multiload.

A DML delete function just like Insert, update, and upsert.

An MLOAD Delete. It uses a query to delete and the only downside is no PI queries and no join queries. It works very fast; between 30,000 and 120,000 rows / second / node. This can be faster than insert / select without the old rows.

Thanks,

Eric

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

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