Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Tue, 14 Aug 2001 @ 11:01:58 GMT





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




Subj:   3+ Tables, Same PI Join Plan
 
From:   Claybourne Barrineau



All (or those interested),

If I have (N) tables (all with the same Primary Index) joined together via inner joins, why can't the Optimizer perform this operation in one logical step instead of (N-1) logical steps?

Is it possible...or better yet, shouldn't it be?


Thanks,

Claybourne Barrineau





     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008