Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Deleting rows from tables
From:   Eric J. Kohut

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.



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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020