Database Reference
In-Depth Information
•
The joining mechanism between two operators in the same column will be a nested loop join,
a hash match join, or a merge join. For example, in the execution plan shown in Figure
7-2
,
there is one hash and one loop join. (Join mechanisms are covered in more detail later.)
•
Running the mouse over a node in an execution plan shows a pop-up window with some
details. The tooltips are not very useful most of the time. Figure
7-3
shows an example.
Figure 7-3.
Tooltip sheet from an execution plan operator
•
A complete set of details about an operator is available in the Properties window, as shown in
Figure
7-4
, which you can open by right-clicking the operator and selecting Properties.