How to find join indexes defined on your table in Teradata
To find the join indexes that are defined on your table, run the following query: 
SELECT  * FROM dbc.indices 
WHERE indextype='J'
     AND databasename='your_database_name'
     AND tablename='your_table_name'
ORDER BY indexname,columnposition;