To find out the list of indexes used in Teradata

By rendering the following query, you can find the list of INDEXes.
SELECT
databasename, tablename, columnname, indextype, indexnumber, indexname
FROM  
dbc.indices
ORDER BY
databasename,  tablename, indexnumber;


For your reference, Please find below the INDEXes used in Teradata.
IndexTypeDescription
PNonpartitioned Primary
QPartitioned Primary
SSecondary
Jjoin index
Nhash index
Kprimary key
Uunique constraint
Vvalue ordered secondary
Hhash ordered ALL covering secondary
Ovalued ordered ALL covering secondary
Iordering column of a composite secondary index
MMulti column statistics
DDerived column partition statistics
1field1 column of a join or hash index
2field2 column of a join or hash index