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

The process of query optimization is very computationally expensive. For this reason, SQL Server stores execution ... this problem in the past: using nested stored procedures based on the value ...