Viewing indexes

Use the Indexes window to view the list of indexes that are defined on the table that is shown in the Table Statistics window.

Authorities and privileges



To view a list of indexes:

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

    The Table Statistics window opens.

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


Related information