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 vote159 views1 answer
Rermove categories woocommerce sql
SQL
5 votes154 views2 answers
Postgres update with if condition query
SQL
0 vote172 views1 answer
SELECT statement to find the specific cell in database table
SQL
2 votes181 views3 answers
Current setting postgres timezone
SQL
3 votes203 views2 answers
Enter mysql command line
SQL
0 vote157 views1 answer
Mysql replication change database name
SQL
0 vote163 views1 answer
Oracle sql drop table
SQL
0 vote153 views1 answer
Oracle last connection
SQL
2 votes161 views1 answer
Oracle to_char number format percentage
SQL
2 votes172 views1 answer
Mysql trigger after update
SQL