ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
Reports information about the fragmentation of database tables.
sa_table_fragmentation ( [ table_name [, owner_name ] ] )
DBA authority required
None
Database administrators can use this procedure to obtain information about the fragmentation in a database's tables. If no arguments are supplied, densities are returned for all tables in the database.
The procedure returns a result set that contains the following columns:
TableName Name of the table
rows Number of rows in the table
row_segments Number of row segments in the table
segs_per_row Number of segments per row
When database tables become excessively fragmented, you can run REORGANIZE TABLE or rebuild the database to reclaim disk space and improve performance.