Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Sep 2005 @ 13:06:28 GMT


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


Subj:   Re: Difference between Delete and delete All
 
From:   Dieter Noeth

Rachana Agarwal wrote:

  What is the difference between Delete and Delete ALL;  


It's the same as:

     delete from  ;

or

     delete  ;

Just syntax...


  Is the second one really faster and why?  


No, both are fast, if it's known to the optimizer, that the transaction is commited after that delete, e.g. BTEQ:

- Implicit transaction in Teradata mode session (auto-commit):

     Delete from ;

- Multistatement including ET in an explicit transaction in Teradata

     mode session:
     bt;
     ...
     Delete from 
     ; et;

- multistatement in ANSI mode session:

     Delete from 
     ;commit;

Dieter



     
  <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