What Is Optimizer Timeout? SQL Server uses a cost-based query optimizer. Therefore, it selects a...

https://docs.microsoft.com/archive/blogs/psssql/understanding-optimizer-timeout-and-how-complex-queries-can-be-affected-in-sql-server