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

See also