|
Reports information about the fragmentation of database tables.
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. See Reducing table fragmentation.
DBA authority required
None