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 vote180 views1 answer
Jooq finding lastest value in table
SQL
2 votes219 views2 answers
How to rename column name in sql server using query
SQL
0 vote189 views1 answer
Select all tables linked server sql
SQL
0 vote186 views1 answer
Like sql for second letter of the family name
SQL
9 votes231 views1 answer
Identity insert on sql server
SQL
1 vote276 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
6 votes194 views3 answers
How to delete table sqlite
SQL
0 vote206 views1 answer
Sql server change schema of a table
SQL
0 vote199 views1 answer
Mod function example
SQL
0 vote201 views1 answer
Mysql insert multiple rows based on select
SQL