Oracle list index on table

SELECT *
FROM ALL_INDEXES		-- or DBA_INDEXES or USER_INDEXES
WHERE TABLE_NAME = 'MY_TABLE' AND OWNER = 'MY_OWNER';

-- Index columns
SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME
FROM DBA_IND_COLUMNS
WHERE TABLE_OWNER = 'MY_OWNER' AND TABLE_NAME = 'MY_TABLE'
ORDER BY TABLE_NAME, COLUMN_POSITION;

Similar codes

2 votes116 views2 answers
Sqlalchemy filter or
SQL
3 votes110 views2 answers
Current year sql
SQL
1 vote148 views1 answer
How not to sort by average rating
SQL
0 vote111 views1 answer
Composit key in sql
SQL
0 vote135 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote121 views1 answer
Sql server select top 2 of each group
SQL
0 vote244 views1 answer
Generate a random otp in sql server
SQL
0 vote117 views2 answers
Sql having multiple conditions
SQL
0 vote127 views2 answers
How to count codition
SQL
0 vote77 views1 answer
Finish transaction sql
SQL