sqlplus ljb/ljb
drop table t1 purge;
drop table t2 purge;
drop table t3 purge;
drop table t4 purge;
drop table t5 purge;
drop table t6 purge;
drop table t7 purge;
create table t1 as select rownum as id ,rownum+1 as id2,rpad('*',1000,'*') as contents from dual connect by level<=1;
create table t2 as select rownum as id ,rownum+1 as id2,rpad('*',1000,'*') as contents from dual connect by level<=10;
create table t3 as select rownum as id ,rownum+1 as id2,rpad('*',1000,'*') as contents from dual connect by level<=100;
create table t4 as select rownum as id ,rownum+1 as id2,rpad('*',1000,'*') as contents from dual connect by level<=1000;
create table t5 as select rownum as id ,rownum+1 as id2,rpad('*',1000,'*') as contents from dual connect by level<=10000;
create table t6 as select rownum as id ,rownum+1 as id2,rpad('*',1000,'*') as contents from dual connect by level<=100000;
create table t7 as select rownum as id ,rownum+1 as id2,rpad('*',1000,'*') as contents from dual connect by level<=1000000;
create index idx_id_t1 on t1(id);
create index idx_id_t2 on t2(id);
create index idx_id_t3 on t3(id);
create index idx_id_t4 on t4(id);
create index idx_id_t5 on t5(id);
create index idx_id_t6 on t6(id);
create index idx_id_t7 on t7(id);
set linesize 1000
set autotrace off
select index_name,
,,,,blevel,
,,,,,leaf_blocks,
,,,,,num_rows,
,,,,,distinct_keys,
,,,,,clustering_factor
,,,从user_ind_statistics
,,在table_name (T1, T2, T3, T4, T5, T6, T7);
INDEX_NAME, BLEVEL LEAF_BLOCKS,NUM_ROWS DISTINCT_KEYS CLUSTERING_FACTOR
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
IDX_ID_T1,,,,0,,,,1,,,,,1,,,,,1,,,,,,,,1
IDX_ID_T2,,,,0,,,,1,,,,10,,,,,,10,,,,,,,2
IDX_ID_T3,,,,0,,,,1,,,,100年,,,,100年,,,,,,,,15
IDX_ID_T4,,,,1,,,,3,,,1000年,,,,,1000年,,,,,,143年
IDX_ID_T5,,,,1,,,,21,,10000年,,,10000年,,,,,,1429年,
IDX_ID_T6,,,,1,,,222年,,100000年,,,,100000年,,,,,14286年
IDX_ID_T7,,,,2,,,2226年,1000000,,1000000,,,,,142858年,
已选择7行。,,