Tables and Indexes
Use this page to review information about the tables, indexes, and fragments in a storage space.
Prerequisites: For the space optimization actions, the IBM® OpenAdmin Tool (OAT) for Informix® requires IBM
Informix 11.50.xC6
or later. For the defragment action, OAT requires Informix 11.70
or later. To compress indexes and simple large objects
(TEXT and BYTE data types), OAT requires Informix 12.10.
- Database
- The database that contains the tables and indexes.
- Top tables or indexes with poor extent utilization
- The three tables or indexes that use the pages most inefficiently. These tables and indexes have the highest percentage of unused and partially used pages.
- Name
- The name of the table or index. To view information about the
table fragments in a fragmented table, expand the table.
- Partition Number
- The fragment identifier.
- Partition Name
- The name of the partition or if the partition is not named, the name of the dbspace that contains the partition.
- Type
- Table or index.
- Rows
- The number of rows in the table, table fragment, or index.
- Extents
- The number of extents in the table, table fragment, 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. Move the cursor over the graphic to view the number of pages of each type.
- Compressed
- An indicator of whether the table, index, or fragment is 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, table fragment, 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 view the number of pages of each type.
- Actions
- Optimize Space
- Compress the selected tables, indexes, and fragments, consolidate free space (repack), return free space to the dbspace (shrink), or merge extents (defragment). You can also uncompress tables and table fragments.
- Update Information
- Estimate of the amount of space that you can save if you compress the selected tables, indexes, and fragments. Update the page usage information for the selected tables, table fragments, and indexes.