how To find join indexes that are defined on your table

1. SELECT * FROM dbc.indices
2. WHERE indextype='J'
3. AND databasename='your_database_name'
4. AND tablename='your_table_name'
5. ORDER BY indexname,columnposition;