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

1 vote156 views1 answer
Ms sql how to see active job current run time
SQL
0 vote190 views1 answer
Power query datetime to date
SQL
8 votes313 views2 answers
Oracle auto increment primary key
SQL
0 vote177 views1 answer
Oracle DROP PROGRAM
SQL
1 vote207 views1 answer
Sql server update column based on another table
SQL
0 vote192 views1 answer
How change the field place in mysql
SQL
0 vote205 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote217 views1 answer
Mysql export data with a where clause
SQL
0 vote201 views1 answer
How to install Firebird
SQL
0 vote189 views4 answers
Database stuck at restoring state
SQL