Databases Reference
In-Depth Information
In order to arrive at what it believes to be the best plan for executing a query, the query
processor performs a number of different steps; the entire query processing process is
shown in Figure 1-1.
Figure 1-1:
The query processing process.
We'll look at this whole process in much more detail later in the topic, but I'll just run
through the steps briefly now.
•
Parsing and binding
- the query is
parsed
and
bound
. Assuming the query is valid,
the output of this phase is a
logical tree
, with each node in the tree representing a
logical operation that the query must perform, such as reading a particular table, or
performing an inner join.