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 vote361 views2 answers
Oracle sql for each row
SQL
0 vote301 views1 answer
Kannst du deine finger trainieren
SQL
16 votes393 views3 answers
T-SQL Add Column
SQL
1 vote358 views1 answer
Cross schema query oracle 2 users
SQL
0 vote349 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
-1 vote343 views1 answer
Add bool column in sql
SQL
1 vote395 views1 answer
Hangfire clear all jobs
SQL
0 vote334 views1 answer
Difference between varchar and varchar2
SQL
0 vote347 views1 answer
Create table with float datatype in sql server
SQL
0 vote363 views1 answer
Dump only data
SQL