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

9 votes263 views2 answers
Default number in sql
SQL
1 vote317 views1 answer
Encrypt password postgresql
SQL
42 votes356 views6 answers
Install beautifulsoup
SQL
1 vote297 views1 answer
Oracle datafile max size 32gb
SQL
0 vote290 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote275 views2 answers
Install phoenix
SQL
0 vote310 views1 answer
Change role postgres
SQL
1 vote282 views1 answer
How to check the mysql version mac
SQL
0 vote280 views1 answer
Mysql two joins
SQL
12 votes296 views10 answers
Google
SQL