Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2009

The most optimal join type

What’s the best join type for a query? Should we aspire to seeing nested loop joins in all our queries? Should we tremble with horror at the sight of a hash join?

Well, it depends.

There’s no single join type that’s best in every scenario and there’s no join type… Read more

0 comments, 508 reads

Posted in SQL In The Wild on 24 November 2009