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.
 
 
Search WWH ::




Custom Search