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

1 vote174 views1 answer
How to see which columns are indexxed mysql
SQL
2 votes191 views1 answer
Install postgresql centos 5
SQL
31 votes181 views4 answers
How to get duplicate records with multiple field in sql
SQL
1 vote186 views1 answer
Replace all numbers in mysql
SQL
0 vote178 views1 answer
Returning with sqlalchemy
SQL
1 vote167 views2 answers
Mysql order by date asc null last
SQL
22 votes174 views4 answers
Tsql rename table
SQL
1 vote161 views1 answer
Postgresql convert text to float
SQL
14 votes185 views3 answers
Inner join sql oracle
SQL
0 vote180 views1 answer
Write sql query to show the details start from digit
SQL