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

0 vote129 views1 answer
Sort by
SQL
0 vote122 views1 answer
What is mysql_pconnect
SQL
5 votes132 views2 answers
Mysql dump mysql db cli
SQL
0 vote141 views1 answer
Ms sql print more than 1 variable
SQL
5 votes139 views6 answers
In operator sql
SQL
0 vote117 views1 answer
Mysql xampp reset root password
SQL
0 vote112 views1 answer
Mysql select where text contains
SQL
1 vote139 views1 answer
Customer using hdfc bank sql query
SQL
0 vote112 views2 answers
Search stored procedures
SQL
5 votes111 views2 answers
Oracle to_timestamp
SQL