Transaction Processing

This is phase zero, and suitable for OLTP-centric queries that are simple yet may have more than one possible query plan. When this phase completes, SQL Server compares the estimated cost of the plan that was found with an internal cost threshold. If the cost of the plan that was found is cheaper than this internal threshold, SQL Server will stop further optimizations and use the plan found by the transaction processing phase.