Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 16:21:13 GMT


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


Subj:   Re: Fast Path Insert
 
From:   Anantaraman, Kumaran (K.)

Thanks Frank,

But this is precisely why I posted the question. The term 'fast path' seems to be used for different levels of optimization. The manual uses fast path to imply *ONLY* the 'no TJ' optimization - did not require matching DDL as you indicate.

There are other levels of optimization

a) no spool required

b) (spool required, but) no sort required on that spool

c) no redistribution required

d) no TJ required

The case Frank cited - matching DDLs with 1 source, will use all the 4 above mentioned optimization levels.

I am picking on the use of term 'fast path' as in the manual to bring out and understand the differences in the 4 optimization levels.

Kumaran Anantaraman



     
  <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: 27 Dec 2016