Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures


sa_table_fragmentation system procedure

Reports information about the fragmentation of database tables.

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

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.

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.


DBA authority required

Side effects


See also