Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 08 Mar 2004 @ 13:17:11 GMT


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


Subj:   Re: Will the 2 SQLs return the same values....
 
From:   Victor Sokovin

  Is there any difference in the 2 SQLs.  


  The problem is that in the 1st SQL, I got only 2 Values for Service and the whole action happens on just 2 AMPS and it becomes skewed.  


  I then changed it to be a SubQuery. Are they both the same.  



It's really hard to say, you know. In the first query you use the column called SERVICE and in the second SERVICE_GROUP.

The use of OUTER JOIN in the second query seems strange unless you want some cross products. As you only take MAX you might not notice that the cross product was used but why would you want it if you care about performance improvement?

Just my 2 cents.


Regards,

Victor



     
  <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: 23 Jun 2019