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.

Fields and controls

Authorities and privileges

To view page fetch pairs statistics:

1. Open the Page Fetch Pairs Statistics window.

2. To save the contents of the window to a file, click on the Save As push button.

3. To print the contents of the window, click on the Print push button.

Information on this view

• Reading the contents of the Page Fetch Pairs Statistics window

Related information

• Creating an access plan graph
• Viewing a graphical representation of an access plan
• Using Visual Explain windows and notebook