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

sa_index_levels system procedure

Function 

To assist in performance tuning by reporting the number of levels in an index.

Syntax 

sa_index_levels ( [ table_name [, owner_name ] )

Permissions 

DBA authority required

Side effects 

None

See also 

CREATE INDEX statement

Using indexes

Description 

The number of levels in the index tree determines the number of I/O operations needed to access a row using the index. Indexes with a small number of levels are more efficient than indexes with a large number of levels.

The procedure returns a result set containing the table name, the index name, and the number of levels in the index.

If no arguments are supplied, levels are returned for all indexes in the database. If only table_name is supplied, levels for all indexes on that table are supplied. If table_name is NULL and an owner_name is given, only levels for indexes on tables owned by that user are returned.