Sql view index

-- Oracle  (all_indexes: depending on grants, dba_indexes: for all indexes))
SELECT index_name FROM user_indexes WHERE table_name = 'MY_TABLE';
-- List of indexed columns:
SELECT index_name, column_position, column_name
FROM user_ind_columns 		-- or all_ind_columns / dba_ind_columns
WHERE table_name = 'MY_TABLE'  
ORDER BY index_name, column_order;

Similar codes

0 vote198 views1 answer
Postgres statistics
SQL
1 vote200 views1 answer
Postgres convert date to string
SQL
3 votes200 views1 answer
Postgres add not null to existing column
SQL
0 vote188 views1 answer
Call rest api from postgresql
SQL
1 vote184 views2 answers
Mysql allow remote connections
SQL
0 vote194 views1 answer
Java check if something is in mysql table
SQL
11 votes234 views1 answer
How to get ddl for materialized view
SQL
0 vote193 views4 answers
How to drop all tables in sql
SQL
2 votes191 views1 answer
Mysql clear screen
SQL
1 vote249 views1 answer
Sql query row number group by
SQL