Viewing Table Page Usage Statistics

Display page usage details of tables or materialized views for the selected SAP Sybase IQ server. Table Page Usage only applies to system tables in the system store (IQ catalog store).

In the Perspective Resources view, select the resource, and select Resource > Monitor Node.
In the left pane of the IQ Node Level Monitor view, select Table Pages.
From the Tables list, select the table or materialized view you want usage details about.

Note:

Click a column header to sort the data by that column.
To display the information in a chart or table in the full window, select the Maximize icon in the top right of the area.

Area	Description
Tables	A list of all tables for the selected resource.
Table Page Usage Details	Table page usage details include: Name – the name of the table or materialized view. Owner – the user with owner privileges for the table or materialized view. Type – the type of table or materialized view. Table Pages – the number of pages in the table or materialized view. Table Pages Used Percentage – the percentage of used pages. Index Pages – the number of pages in the index of the table or materialized view. Index Pages Used Percentage – the percentage of used index pages. File Used Percentage – the percentage of the file that is used.

Area

Description

Tables

A list of all tables for the selected resource.

Table Page Usage Details

Table page usage details include:

Name – the name of the table or materialized view.
Owner – the user with owner privileges for the table or materialized view.
Type – the type of table or materialized view.
Table Pages – the number of pages in the table or materialized view.
Table Pages Used Percentage – the percentage of used pages.
Index Pages – the number of pages in the index of the table or materialized view.
Index Pages Used Percentage – the percentage of used index pages.
File Used Percentage – the percentage of the file that is used.