Oracle索引问题

注意大小写
查询索引在哪个表中

select * from all_indexes where index_name = '';
select * from all_cons_columns where constraint_name = '';

查询此表所有用户的索引

SELECT * FROM dba_indexes WHERE table_name = '';