Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2005 @ 11:44:11 GMT


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


Subj:   Re: Insert into empty table with statistics
 
From:   David Wellman

Hi Mirjam,

The fast-path insert choice is made by each individual AMP at the start of the Merge step. You will not see anything in the explain which says whether or not the fast-path was chosen. The only way I know to tell is by seeing how fast it runs !


Cheers,

Dave



     
  <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