Viewing referenced column statistics

Use the Referenced Column Statistics window to view statistics for a column that is referenced in a selected table.

Authorities and privileges

To view referenced column statistics:

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 Referenced Columns push button. The Referenced Columns window opens.
4. Select one or more entries and click OK. A Referenced Column Statistics window opens for each column that is selected.
5. Press F1 or click the Help push button for instructions on how to use this window.

Related information

• Viewing a graphical representation of the Access Plan for an explained SQL statement.