察看某表上建立的索引情况

select index_name,column_name,column_position from dba_ind_columns where
table_owner='XXXX' and table_name = 'XXXX' order by 1,3;

select index_name from user_indexes where TABLE_NAME='XXXX';

转载于:https://blog.51cto.com/yeluyide/1135391