Viewing page fetch pairs statistics

Use the Page Fetch Pairs Statistics window to view the estimated number of page fetches for each hypothetical number of buffer pages as an ordered set of pairs. The numbers model the number of I/Os required to read the data pages into buffer pools of various sizes.

Authorities and privileges



To view page fetch pairs statistics:

  1. Create an access plan using the Command Center.
  2. To see statistics on an Index node in the graph, do one of the following:
    1. Highlight the index node and select Access plan->Node->Show statistics.
    2. Double-click the index node.
    3. Click mouse button 2 on the index node and select Show statistics from the pop-up menu.

    The Index Statistics window opens.

  3. Click the Page Fetch Pairs push button. The Page Fetch Pairs Statistics window opens.
  4. Press F1 or click the Help push button for instructions on how to use this window.


Related information