Contents Index sa_statement_text system procedure sa_table_page_usage system procedure

ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_table_fragmentation system procedure


Function 

Reports information about the fragmentation of database tables.

Syntax 

sa_table_fragmentation ( [ table_name [, owner_name ] ] )

Permissions 

DBA authority required

Side effects 

None

See also 

Table fragmentation

Defragmenting tables

Rebuilding databases

REORGANIZE TABLE statement

Description 

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:

When database tables become excessively fragmented, you can run REORGANIZE TABLE or rebuild the database to reclaim disk space and improve performance.


Contents Index sa_statement_text system procedure sa_table_page_usage system procedure