ref:http://support.microsoft.com/kb/197297/en-us INF: Comparison of Join Techniques
This article was previously published under Q197297
SUMMARY
Microsoft SQL Server version 7.0 includes some new join techniques, such as the hash join and sort-merge join, to supplement nested-loop join
|