Viewing index statistics

Use the Index Statistics window to view statistics for an index node selected in the Access Plan Graph or an index entry selected in the Indexes window.

Fields and controls

Authorities and privileges

To view index statistics:

1. Open the Index Statistics window.
2. To show statistics for page fetch pairs, click on the Page Fetch Pairs push button.
3. To save the contents of the window to a file, click on the Save As push button.
4. To print the contents of the window, click on the Print push button.

Information on this view

• Reading the contents of the Index Statistics window

Related information

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