Open the Index Statistics window

To open the Index Statistics window, use one of the following methods:

• Open the Access Plan Graph window. Do one of the following:

  • To see statistics on an Index node in the graph, do one of the following:
    • Highlight the index node and select Node->Show statistics.
    • Double-click on the index node.
    • Click mouse button 2 on the index node and select Show statistics from the pop-up menu.

    The Index Statistics window opens.

  • To see statistics on other indexes defined for a Table node in the graph, do one of the following:
    • Highlight the table node and select Node->Show statistics.
    • Double-click on the table node.
    • Click mouse button 2 on the table node and select Show statistics from the pop-up menu.

    The Table Statistics window opens. Click on the Indexes push button to open the Indexes window. Select one or more entries in the Indexes window and click on OK. An Index Statistics window opens for each entry that you select.

• Create an access plan using the Command Center. Do one of the following:

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

    The Index Statistics window opens.

  • To see statistics on other indexes defined for a Table node in the graph, do one of the following:
    • Highlight the table node and select Access plan->Node->Show statistics.
    • Double-click on the table node.
    • Click mouse button 2 on the table node and select Show statistics from the pop-up menu.

    The Table Statistics window opens. Click on the Indexes push button to open the Indexes window. Select one or more entries in the Indexes window and click on OK. An Index Statistics window opens for each entry that you select.