Viewing table function statistics

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

Before you begin...

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.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]