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 vote138 views6 answers
Unique key in sql
SQL
0 vote133 views1 answer
Install mysql for fedora 34
SQL
0 vote194 views1 answer
Radius search with point data in mysql
SQL
-1 vote144 views1 answer
Can pandas fetch data from sql
SQL
2 votes142 views1 answer
Change primary key sql
SQL
0 vote145 views1 answer
How to add boolean column in postgresql
SQL
0 vote146 views1 answer
Drop-toys-table
SQL
0 vote100 views4 answers
Sql limit 1 offset 1
SQL
0 vote134 views2 answers
Postgresql change user role grant
SQL
1 vote147 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL