The index glossary query returns name of the indexed table and the columns used by the index referenced by the specified name.
View type: DAQOracleIndex
Modifications:
Change the search criteria of the index name using the = (equals), IN or LIKE elements in the SQL WHERE clause. The WHERE clause may be changed to locate all indexes which match the specified characteristics. In order to provide unique Oracle index names, the name has the format <>RelSystem:Schema:::IndexName<variation:revision>.
To find all DB2/390 indexes which have a specific simple name, use the LIKE clause with % as either of the first two qualifiers. To speed up your query, use % to include the colons and separators. For example, if you want all indexes starting "CUST", specify LIKE '%::CUST%'.