Viewing referenced columns

Use the Referenced Columns window to view the list of columns that are associated with the SQL statement whose access plan is shown in the graph.

These columns belong to the table that is shown in the Table Statistics window.

Before you begin...

To view a list of referenced columns:

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