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 vote144 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote208 views1 answer
Mysql aspas simples
SQL
20 votes212 views6 answers
Creating a table in sql
SQL
0 vote187 views1 answer
Check if table exists oracle
SQL
0 vote197 views1 answer
Exit psql
SQL
0 vote182 views1 answer
Arithmetic expression in sql
SQL
0 vote208 views1 answer
Sort by
SQL
0 vote187 views1 answer
Mysql concat and use as where column
SQL
3 votes190 views2 answers
How to list columns for particular tables in postgresql
SQL
5 votes185 views1 answer
How to check port number for postgresql
SQL