Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 18 Feb 2004 @ 21:25:38 GMT


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


Subj:   Re: Inner Join on 1=1
 
From:   Jason Fortenberry

Joseph, It is doing a cross join as explained. It is joining every record of table a with every record of table b. Normally you will see this in explain plans where the optimizer is joining 2 tables that are not explicitly joined in the query. Ummm....usually you want to avoid this if possible. If that is your case, try defining an ON CLAUSE that defines columns to join between a and b.


--Jason



     
  <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