| Name the four types of physical JOIN operations in SQL Server?
Below are the four types of physical JOIN operations in SQL:-
(1)Nested Loop Joins:-These join applied when one join input is small and other join input is large because nested loop join require minimum I/O and few comparisons.
(2)Merge Joins:-These types of joins used where two inputs are large and of the same size and sorted out based on the join column,then merge join will provide a fast join operation.
(3)Hash Joins:-Here this types of join efficiently process large, non-indexed and unsorted inputs. And these are also helpful in getting intermediate results in complex queries.
(4)Adaptive Joins:-Here in these types of join helps to decide when to switch to a bested loop based on a threshold value. | | |