Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 JOIN Performance

Author  Topic 

Blastrix
Posting Yak Master

208 Posts

Posted - 2002-01-08 : 11:23:40
How much a performance hit is it to use OUTER Joins as opposed to INNER Joins?

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-01-08 : 13:11:43
I don't know that there's a significant difference in performance other than the fact that they will return different resultsets if you have any unmatched rows. Your needs may require you to use OUTER joins.

--------------------------------------------------------------
1000 Posts, Here I come! I wonder what my new title will be...
Go to Top of Page
   

- Advertisement -