The Query Optimizer contains many optimization phases that each perform different functions. The different phases help the Query Optimizer perform the highest-value operations earliest in the optimization process.
The major phases in the optimization of a query, as shown in Figure 11-14, are as follows:
Convert to executable plan
Figure 11-14. Query Optimizer pipeline.
The SQL Server query processor performs several steps before the actual optimization process begins. These transformations help shape the tree into a form that’s ...