Merge join Vs Hash join Vs Nested loop join « Sql server Blog Forum

Table size With index (Both) Without Index(Both) Either of table has index Big (Both) HASH HASH HASH Medium (Both) HASH HASH HASH Small (Both) NESTED LOOP NESTED LOOP HASH Big Vs Small(medium) HASH HASH HASH

www.sqlserverblogforum.com