Show TOC

Space: Tables and IndexesLocate this document in the navigation structure

Use

You can access the Tables screen by calling the DBA Cockpit and choosing Start of the navigation path Space Next navigation step Tables End of the navigation path in the navigation frame of the DBA Cockpit.

The Tables screen displays information on all tables of the database, such as the used, unused or reserved space, the number of rows, the number of rows deleted, forwarded, and so on.

In the Selection area, you can specify the time frame and other criteria for which you want the tables to be displayed.

To analyze table data, you proceed as follows:

  1. You specify the time frame and other criteria for which you want the tables to be displayed.

  2. To refresh table data, you choose the Apply Selection push button. The following information is displayed:

Column:

Description:

Database

Name of the database

Table Owner

Name of the table owner

Table Name

Name of the table

Reserved Total (KB)

Space reserved for future inserts

Used Total

Total amount of space used in KB

Unused Total

Total amount of unused space in KB

Data Total (KB)

Amount of data for this table in KB

Data Utilized Total

Amount of utilized data for this table in KB

Number of Rows

Table rows

Data Change

Percentage of data change since the last statistics update was performed on the object

Data Cluster Ratio

Data cluster ratio in %

Large IO Efficiency

Information about I/O efficiency

Deleted Rows

Number of data records that were deleted

Forwarded Rows

Rows that grow in length with subsequent updates

To display further details of the selected table, you select a line in the overview table and choose Table Details . By analyzing and maintaining single tables, you can optimize tables and indexes to:

  • Save disk space by releasing unused space

  • Improve access to a table by keeping statistics up-to-date or by reorganizing fragmented tables or indexes

The Single Table Analysis screen consists of the following areas:

  • A selection area, where you specify the schema and name of the table to be analyzed

  • Tab pages with detail information that is relevant for tables and indexes