sa_table_page_usage system procedure

Reports information about the page usage of database tables.

Syntax

sa_table_page_usage( )

Result set

Column name	Data type	Description
TableId	UNSIGNED INTEGER	The table ID.
TablePages	INTEGER	The number of table pages used by the table.
PctUsedT	INTEGER	The percentage of used table page space.
IndexPages	INTEGER	The number of index pages used by the table.
PctUsedI	INTEGER	The percentage of used index page space.
PctOfFile	INTEGER	The percentage of the total database file the table occupies.
TableName	CHAR(128)	The table name.

Remarks

The results include the same information provided by the Information utility. When the progress_messages database option is set to Raw or Formatted, progress messages are sent from the database server to the client while the sa_table_page_usage system procedure is running.

Privileges

You must have the MANAGE ANY DBSPACE system privilege.

Side effects

None

Example

The following example obtains information about the page usage of the SalesOrderItems table.

SELECT * FROM sa_table_page_usage( )
    WHERE TableName = 'SalesOrderItems';