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 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 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.