X hits on this document

113 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 views113
Page views113
Page last viewedThu Dec 08 06:36:18 UTC 2016
Pages48
Paragraphs987
Words15822

Comments