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: 28 Jun 2020