Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 02 Mar 2011 @ 09:23:51 GMT


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


Subj:   Re: END TRANSACTION step - long when deleting
 
From:   Minakshi Swami

Hi Dieter,

I partially agree with your last statement(please correct me if I am wrong):

An MLoad Delete used to be always faster than a SQL Delete, but it's no longer true To me mload delete give same performance when compared with delete all but delete with where clause is slower than mload delete mode(because of no TJ) and this applicable to TD13 as well.



     
  <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: 15 Jun 2023