Retrieving catalog information about indexes

The SYSIBM.SYSINDEXES table contains a row for every index, including indexes on catalog tables.

Procedure

Begin general-use programming interface information.

To obtain information about indexes:

Query the SYSIBM.SYSINDEXES table.

For example, to retrieve a row about an index named XEMPL2:

SELECT *
  FROM SYSIBM.SYSINDEXES
  WHERE NAME = 'XEMPL2'
  AND CREATOR = 'DSN8C10';

A table can have more than one index. To display information about all the indexes of a table:

SELECT *
  FROM SYSIBM.SYSINDEXES
  WHERE TBNAME = 'EMP'
  AND TBCREATOR = 'DSN8C10';

End general-use programming interface information.