The SQL Server query optimizer would first construct a query plan for a batch of T-SQL code ... SQL Server typically chooses between three types of physical join operators: nested loop joins, merge ...