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

sa_index_density system procedure

Function 

Reports information about the amount of fragmentation within database indexes.

Syntax 

sa_index_density ( [ table_name [, owner_name ] ] )

Permissions 

DBA authority required

Side effects 

None

See also 

Index fragmentation

Description 

Database administrators can use this procedure to obtain information about the degree of fragmentation in a database's indexes.

The procedure returns a result set containing the table name, the index name, the number of leaf pages, and the index's density. The density is a fraction between 0 and 1.

If you do not specify parameters, the information for all tables appears. Otherwise, the procedure examines only the named table.

The Interactive SQL Results pane shows you a result set for the table as follows:

TableName, IndexName, LeafPages, Density

Density is a fraction between 0 and 1. For indexes with a high number of leaf pages, higher density values are desirable.