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 vote366 views1 answer
Homebrew install mysql
SQL
9 votes330 views1 answer
Sql server get utc date
SQL
4 votes317 views3 answers
Count with where
SQL
0 vote429 views1 answer
Restart serial number for postgres
SQL
0 vote323 views1 answer
Mysql add to value
SQL
8 votes365 views2 answers
Between operator
SQL
0 vote377 views1 answer
Postgres rename database
SQL
0 vote323 views1 answer
Use where instead of join
SQL
0 vote337 views1 answer
Connexion mysql
SQL
0 vote306 views1 answer
Suse start MySQL
SQL