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 vote254 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
7 votes257 views1 answer
Buy forge mods server hosting
SQL
0 vote236 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote236 views1 answer
Linked server delete openquery
SQL
1 vote267 views1 answer
Mysql update inner
SQL
1 vote240 views1 answer
How to delete a record from sqlite in android
SQL
0 vote229 views1 answer
Mysqldump don't drop table
SQL
0 vote230 views1 answer
Jooq replace
SQL
0 vote243 views1 answer
Oracle cpu metric
SQL
0 vote233 views1 answer
Alter table fulltext
SQL