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).

  1. In the Perspective Resources window, select the resource, click the arrow, and select Monitor Node.
  2. In the left pane of the IQ Node Level Monitor view, select Table Pages.
  3. 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.

Related tasks
Viewing Overview Statistics
Viewing All Statistics
Viewing Engine Statistics
Viewing Connection Statistics
Viewing Transaction Statistics
Viewing Dbspaces Statistics
Viewing Store I/O Statistics
Viewing Cache Statistics
Viewing Table Version Statistics
Viewing Operations and Requests Statistics
Viewing Network Statistics
Viewing Table Lock Details
Viewing Deadlock Details
Viewing Monitor Settings Details