Viewing Table Page Usage Details

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 window, select the resource, click the arrow, and select 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: 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	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

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.