实验:
create table testindex as select * from dba_objects ;
create index id_index on testindex(object_id);
analyze index id_index validate structure ;
select btree_space,used_space,pct_used,blocks,lf_blks,br_blks,height from index_stats;
实验:
create table testindex as select * from dba_objects ;
create index id_index on testindex(object_id);
analyze index id_index validate structure ;
select btree_space,used_space,pct_used,blocks,lf_blks,br_blks,height from index_stats;