You can use the following SQL when you want to check the indexes in the Teradata database system:
SELECT databasename, tablename, columnname, indextype, indexnumber, indexname FROM dbc.indicesORDER BYindextype
The following are the types of indexes available:
| IndexType | Description |
| P | Non-partitioned primary |
| Q | Partitioned primary |
| S | Secondary |
| J | Join |
| N | Hash |
| K | Primary key |
| U | Unique constraint |
| V | Value ordered secondary |
| H | Hash ordered ALL covering secondary |
| O | Valued ordered ALL covering secondary |
| I | Ordering column of a composite secondary index |
| M | Multi-column statistics |
| D | Derived column partitioned statistics |
| 1 | field1 column of a join or hash index |
| 2 | field2 column of a join or hash index |
Hash indexes ...
