The following SELECT statement displays the join indexes defined on the table user1.oneoneone:
SELECT joinidxdatabasename, joinidxname FROM DBC.JoinIndicesV WHERE databasename = 'user1' and tablename = 'oneoneone';
Result:
JoinIdxDataBaseName JoinIdxName ------------------- ------------ user1 ji