[dba-SQLServer] outer joins?

OTTOMH I can't think of an instance for needing an outer join unless it's 
for the request of the data, (likewise an inner join). As far as performance 
you're going to on the avg return more rows in an OUTER JOIN (right?), thus 
more time,

On 5/3/05, Billy Pang <tuxedo_man at hotmail.com> wrote:
> 
> 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
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...