Database Reference
In-Depth Information
The following techniques are performed in order, as shown in Figure
14-1
.
•
Parsing
•
Binding
•
Query optimization
•
Execution plan generation, caching, and hash plan generation
•
Query execution
Algebrizer
T-SQL Statement
Parser
Parse Tree
DML Statement?
No
Yes
Object Binding
Query Processor
Tree
Storage Engine
Optimizer
Figure 14-1.
SQL Server techniques to optimize query execution
Let's take a look at these steps in more detail.