1.查看执行计划:
explain plan for select * from table_name where ....
select * from table(dbms_xplan.display);
2.查看索引的列:
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('表名') ORDER BY a.table_name, a.index_name, a.column_position;
3.创建索引更新索引:
CREATE INDEX
IDEX_PHONE-->索引名称
ON
USER-->表名
(
PHONE-->字段名
);