Nested Select vs Outer Join
465919Apr 9 2012 — edited Apr 9 2012I know the result of using outer join instead of a nested select will be the same but I'm curious to know the effect on performance and your opinions on it. This is just a simple example by the way. The query I am working on has about 6 nested selects I am trying to optimize it by changing it to outer joins. I have done performance testing on this and so far the results are the same but my superior kept insisting to change the query to outer join instead of inner select. I argued there would be no need to change the query since the effect on performance would be the same. Would it really be better to use outer join instead? or does it have other benefits?
Please see this link. I am having problems posting the whole content here. Dont know why.
http://pastie.org/3759303
Thanks, I would appreciate any form of help.
Edited by: user462916 on Apr 9, 2012 6:55 PM