[dba-SQLServer] outer joins?

Billy Pang tuxedo_man at hotmail.com
Wed May 4 01:47:50 CDT 2005


Hello:

Can I ask for the group's opinion about something?  Is there any performance 
differences between an INNER JOIN and an OUTER JOIN query?  I know the two 
joins may or may not produce the same resultset (depending on data) but I am 
curious if anyone has come across any difference in terms of performance, 
generally speaking of course.  Should OUTER JOINs be avoided in general 
unless absolutely necessary?

Thanks

Billy





More information about the dba-SQLServer mailing list