sa_table_fragmentation system procedure

Reports information about the fragmentation of database tables.

Syntax

sa_table_fragmentation(
  [ tbl_name
  [, owner_name ] ]
)

Arguments

tbl_name Use this optional CHAR(128) parameter to specify the name of the table to check for fragmentation.
owner_name Use this optional CHAR(128) parameter to specify the owner of tbl_name.

Result set

Column name	Data type	Description
TableName	CHAR(128)	Name of the table.
rows	UNSIGNED INTEGER	Number of rows in the table.
row_segments	UNSIGNED BIGINT	Number of row segments in the table.
segs_per_row	DOUBLE	Number of segments per row.

Remarks

Database administrators can use this procedure to obtain information about the fragmentation in a database's tables. If no arguments are supplied, results are returned for all tables in the database.

When database tables become excessively fragmented, you can run REORGANIZE TABLE or rebuild the database to reduce table fragmentation and improve performance. See Reducing table fragmentation.

Permissions

DBA authority required

Side effects

None