December 5, 2009 at 6:40 pm
Please help me with the following THREE questions:
1) True or False, specifying a join hint will force join order?
2) When joining two small row sets together on an inner join, which join type is generally preferred?
a. Hash Join
b. Merge Join
c. Loop Join
3) What is the difference between a hash join and a merge join?
Thank you.
December 5, 2009 at 6:56 pm
This looks like homework. You ought to be able to easily search out the first and third items. A few links for you to read:
http://blogs.msdn.com/craigfr/archive/2006/08/10/687630.aspx
http://blogs.msdn.com/craigfr/archive/2006/08/03/merge-join.aspx
http://blogs.msdn.com/craigfr/archive/2006/07/26/679319.aspx
December 5, 2009 at 10:44 pm
There's really no need to start a new thread with exactly the same question that you asked yesterday.
No replies to this thread please. Asked and answered here: http://www.sqlservercentral.com/Forums/Topic829341-1291-1.aspx
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply