Viewing table function statistics

Use the Table Function Statistics window to view statistics for a table function node selected in the access plan graph.

Authorities and privileges



To view table function statistics:

  1. Create an access plan using the Command Center.

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

    The Table Function Statistics window opens.

    If the node is GENROW, only explained statistics are displayed; otherwise, both explained and current statistics are displayed.

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


Related information