Tables and Indexes

Use this page to review information about the tables and indexes in the database that contain time series.

Space

The dbspace or sbspace that contains the tables and indexes.

Name

The name of the table or index.

Type

Table or index.

Rows

The number of rows in the table or index.

Extents

The number of extents in the table or index.

Space Usage

A representation of how the space is used. The column represents the total number of pages, for example, 200. Red indicates the number of used pages and green represents the number of free pages, for example, 150 used pages and 50 free pages. If an estimate is available, pink partially overwrites the red to show the estimated pages saved, and red shows the estimated pages used. Green still shows the number of free pages. For example, 25 saved pages, 125 used pages, and 50 free pages.

Compressed

An indicator of whether the row represents a compressed table, a table that is not compressed, or an index. Indexes cannot be compressed. A check mark and an X together indicate that some but not all fragments in a table are compressed. A clock indicates that a compression task is running, but not completed. To monitor the progress of the task, click the Task Status tab.

Used Pages

The number of pages that are used in the table or index.

Page Usage

An indicator of the number of full, mostly used, partially used, and unused pages for the table or index. Move the cursor over the graphic to display the number of pages of each type.

Actions

Optimize Space

Compress or uncompress the selected tables, consolidate free space (repack), return free space to the dbspace (shrink), or merge extents (defragment). You can also defragment indexes.

Update Data

Estimate of the amount of space that you can save if you compress the selected tables or table fragments. Update the page usage information for the selected tables, table fragments, and indexes.