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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_statement_text system procedure Next Page

sa_table_fragmentation system procedure

Reports information about the fragmentation of database tables.


[ tbl_name
[, owner_name ] ]

Result set
Column nameData typeDescription
TableName CHAR(128)Name of the table.
rowsUNSIGNED INTEGERNumber of rows in the table.
row_segmentsUNSIGNED BIGINTNumber of row segments in the table.
segs_per_rowDOUBLENumber 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