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 vote354 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote328 views1 answer
Sql server size of every table in a db
SQL
11 votes308 views1 answer
How to get ddl for materialized view
SQL
0 vote321 views1 answer
Postgres copy command
SQL
1 vote321 views1 answer
Check if mysql is installed
SQL
2 votes351 views1 answer
Oracle block
SQL
6 votes346 views2 answers
Difference between join vs union
SQL
3 votes311 views1 answer
Oracle undo tablespace list by user
SQL
1 vote309 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote331 views1 answer
Mysql join only one column
SQL