X hits on this document

145 views

0 shares

0 downloads

0 comments

15 / 48

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

649

Document info
Document views145
Page views145
Page last viewedWed Jan 18 16:34:09 UTC 2017
Pages48
Paragraphs987
Words15822

Comments