Viewing table space statistics

Use the Table Space Statistics window to view statistics for a table space that is associated with the explained SQL statement.

For more information on table spaces, see the section on designing and choosing table spaces in the Administration Guide.

Authorities and privileges

To view table space statistics:

1. Create an access plan using the Command Center.
2. Do one of the following:
   • Select Access plan->Statement->Show statistics->Table spaces.
   • Deselect all nodes in the graph. Click mouse button 2 on the graph background and select Access plan->Show statistics->Table spaces from the pop-up menu.

   The Table Spaces window opens.

3. Select one or more entries and click OK. A Table Space Statistics window opens for each table space that is selected.
4. 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.