1、查看表中有哪些索引
select * from user_indexes where table_name = '表名'
或者
select * from all_indexes where table_name = '表名'
2、查看表中索引对应哪些列
select * from user_ind_columns where table_name='表名'
1、查看表中有哪些索引
select * from user_indexes where table_name = '表名'
或者
select * from all_indexes where table_name = '表名'
2、查看表中索引对应哪些列
select * from user_ind_columns where table_name='表名'