[dba-SQLServer] outer joins?

Charlotte Foust cfoust at infostatsystems.com
Wed May 4 10:26:31 CDT 2005


My experience, admittedly subjective, is that outer joins are FASTER
than inner joins, perhaps because an outer join only evaluates one table
to find matches rather than having to walk the indexes in both tables.

Charlotte Foust


-----Original Message-----
From: Francisco Tapia [mailto:fhtapia at gmail.com] 
Sent: Tuesday, May 03, 2005 11:56 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list