Joins

Question

Post reply

Joins

balaji.ganga

SSCrazy

Points: 2280
More actions
June 21, 2010 at 3:14 am

#75570

Hi All,
I have a question, so many joins are there like inner join,outer join,
left outer join, right outer join, full outer join,cross join,self join,
merge join,hash join etc.. in which joins given more performance?
I would be greatly appreciated, if any body reply me asap.
Thanks & Regards
Balaji.G

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

First Off

Inner joins and Outer joins are functionly different, so a performance comparison is irrevlant.

The true answer is , It Depends.

The different join types (Merge , Hash ,Loop) will ALL be fastest and ALL be slowest depending on the data they are joining.

Clear Sky SQL
My Blog[/url]

balaji.ganga SSCrazy Points: 2280 More actions · Answer 2

balaji.ganga

SSCrazy

Points: 2280

June 21, 2010 at 4:48 am

#1182651

Thanks Dave

Regards

Balaji.G

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Have you tried google?

http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/

http://sqlinthewild.co.za/index.php/2009/11/24/the-most-optimal-join-type/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

balaji.ganga SSCrazy Points: 2280 More actions · Answer 4

yes Mr Gail. But its does n't have correct information.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

http://www.google.com/search?q=inner+Join+site%3Amsdn.microsoft.com

http://www.google.com/search?q=Left+Outer+Join+site%3Amsdn.microsoft.com

http://www.google.com/search?q=Right+Outer+Join+site%3Amsdn.microsoft.com

http://www.google.com/search?q=cross+Join+site%3Amsdn.microsoft.com

http://www.google.com/search?q=self+Join+site%3Amsdn.microsoft.com

http://www.google.com/search?q=merge+Join+site%3Amsdn.microsoft.com

http://www.google.com/search?q=hash+Join+site%3Amsdn.microsoft.com

http://www.google.com/search?q=loop+Join+site%3Amsdn.microsoft.com

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 6

balaji.ganga (6/21/2010)
yes Mr Gail. But its does n't have correct information.

correct information ????

What doesnt ?

Clear Sky SQL
My Blog[/url]