Archives of the TeradataForum
Message Posted: Mon, 25 Sep 2001 @ 01:23:19 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|