Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 11 Dec 2008 @ 15:54:53 GMT


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


Subj:   Re: Rank and Delete?
 
From:   Geoffrey Rommel

  The manual provides information on differences in DELETE statements in the so called "Import Tasks" and "Delete Tasks". The latter are less restrictive in their syntax, for example, but they would imply a full table scan and you are probably not much better off performance-wise than with BTEQ.  


Sorry to disagree with you, Victor, but MultiLoad Delete is faster than an ordinary SQL delete. It apparently uses a different algorithm to handle the blocks. I once deleted a billion rows in about 15 minutes (intentionally :-) ).



     
  <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