IBM Books

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.

Graphic of Overview push button appears here.
Figure rule not displayed.

Before you begin...
Figure rule not displayed.

To view index 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 on 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. Press F1 or click on the Help push button for instructions on how to use this window.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]