Viewing column distribution statistics

Use the Column Distribution Statistics window to view the column distribution values for a column that is shown in the Referenced Column Statistics window.

Authorities and privileges



To view column distribution 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 on 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 on the Referenced Columns push button. The Referenced Columns window opens.

  4. Select one or more entries and click on OK. A Referenced Column Statistics window opens for each column that is selected.

  5. Click on the Column Distribution push button. The Column Distribution Statistics window opens.

  6. Press F1 or click on the Help push button for instructions on how to use this window.


Related information