Understanding Optimizer Timeout and how Complex queries can be Affected in SQL Server

(Joseph.Pilov) SQL Server uses a cost-based query optimizer. Therefore, it selects a query plan with the lowest cost after it has built and examined multiple query plans.

Register to Read