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
 General SQL Server Forums
 New to SQL Server Programming
 Which is better

Author  Topic 

WoodHouse
Posting Yak Master

211 Posts

Posted - 2010-05-12 : 02:41:51
Which is better? A nested loop join or a hash join in SQL SERVER if two big tables are joined to produce results.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-05-12 : 03:11:47
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
SQL Server MVP
Go to Top of Page

kashyapsid
Yak Posting Veteran

78 Posts

Posted - 2010-05-12 : 03:16:12
the links are very fine

KaShYaP
Go to Top of Page

WoodHouse
Posting Yak Master

211 Posts

Posted - 2010-05-12 : 03:25:00
Thanks a Lot Gail Shaw
Go to Top of Page
   

- Advertisement -