Queries about created indexes are to be started on the table 'domain.ind_uses_col'. As described for the synonym definitions, a distinction is made between created objects and objects referencing the created objects.
To obtain a clear display, several columns should be renamed.
For convenient restrictions, a table name or a special index name could be used. Otherwise, a list is displayed containing all indexes created on objects for which the current user has privileges.
SELECT defowner owner,
deftablename tablename,
defindexname indexname,
type,
refcolumnname columnname,
pos,sort,
createdate "date",
createtime "time"
FROM domain.ind_uses_col
WHERE deftablename = 'CUSTOMER'
ORDER BY owner,tablename,indexname,pos
