Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Jan 2000 @ 22:29:35 GMT


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


Subj:   Re: Nested Left Joins
 
From:   Fred Pluebell

Reading between the lines...

It appears C1 is the primary index for both T1 and T3, and (C1,C2) is the primary index for T2. The following query gives the same results, but may run faster:

     REPLACE VIEW V1(...) AS SELECT ...
     FROM
     (T1 LEFT OUTER JOIN T3 ON T1.C1 = T3.C1)
     LEFT OUTER JOIN T2 ON T2.C1 = T1.C1 AND T2.C2 = T3.C2;


     
  <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