Archives of the TeradataForum
Message Posted: Mon, 08 Mar 2004 @ 13:17:11 GMT
| 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
| ||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.