sa_table_fragmentation system procedure

sa_table_fragmentation(
  [ tbl_name
  [, owner_name ] ]
)

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.

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.

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.

DBA authority

None

CALL sa_table_fragmentation( 'Products','GROUPO' );

sa_table_fragmentation system procedure

Syntax

Arguments

Result set

Remarks

Permissions

Side effects

See also

Example