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.


Thanks,

Eric

EJK
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: 27 Dec 2016