第十二章Managing Indexes
analyze index t_idx1 validate structure;
select height,name,lf_rows,lf_blks,del_lf_rows from index_stats;
alter index t_idx1 rebuild;
drop index
1、批量导入数据前删除索引,之后再创建索引
2、删除不常用的索引,需要的时候再创建索引
3、删除无效索引
drop index t_idx1;
区分未使用的index
alter index t_idx1 monitoring usage;
alter index t_idx1 nomonitoring usage;
select * from v$object_usage;