CHAPTER 28 ■ PERFORMANCE TUNING
Figure 28-13. Cost relative to Batch Query 2
To get more information about an individual operation, you can hover your mouse pointer over it. This returns a ToolTip window which shows information about the specific operation, includ- ing a description of what each operator actually does, the number of rows impacted, and more (see Figure 28-14).
Figure 28-14. A ToolTip
Other visual indicators you can look out for include thick arrows. Arrows become thicker based on the number of rows being passed from operator to operator. Hovering over the arrow gives you ToolTip information for the number of rows being passed to the next operation. Figure 28-15 shows the ToolTip for a Hash Match operator:
Figure 28-15. A ToolTip for an arrow