Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 07 Jul 2003 @ 15:28:27 GMT


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


Subj:   Re: Question Regarding Multi-Statement Transactions in BTEQ
 
From:   Dempsey, Mike

Using this syntax the statements would be executed in parallel. If each item was destined for a different AMP the parallel query would probably run about 3 times faster than if the statements were executed sequentially.

(You can do the same thing in SQL Assistant by using the 'Execute Parallel' button. In this case it makes no difference where you place the semi-colons.)

Mike Dempsey
Teradata Client Tools



     
  <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