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

13 votes192 views5 answers
Select last row mysql
SQL
1 vote199 views1 answer
Postgres concat_ws
SQL
1 vote207 views1 answer
Sql server today minus n
SQL
0 vote225 views1 answer
Google cloud sql postgres url example
SQL
0 vote206 views2 answers
Postgresql variable in query
SQL
2 votes209 views2 answers
How to run postgresql in linux
SQL
0 vote214 views1 answer
Helptext in sql
SQL
1 vote199 views1 answer
Sql server list locks
SQL
10 votes276 views1 answer
Oracle all_dependencies
SQL
1 vote225 views1 answer
Sql first
SQL