oracle查询索引
SELECT b.uniqueness, a.index_name, a.table_name, a.column_name
FROM all_ind_columns a, all_indexes b
WHERE a.index_name=b.index_name
AND a.table_name = upper('&tab_name')
ORDER BY a.table_name, a.index_name, a.column_position;
创建索引
creat index 索引名称 on 表名(列名,列名)
删除索引
drop index 索引名称