Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Jul 2004 @ 15:43:41 GMT


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


Subj:   Re: Impact of Failed Queries
 
From:   Victor Sokovin

  Not only the PE but other components too consume resources for failed queries. e.g. duplicate row are found when doing a merge at the bynet from all amps.  


INSERT ... SELECT statements sometimes fail only in the INSERT phase. For example, when you have a SUM in the SELECT, and the aggregated values do not fit into the target table for some rows. Resources will be consumed during the query and the rollback.


Victor



     
  <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: 23 Jun 2019