拷贝统计信息

1.环境部署

1.1创建表和索引

SQL> create table jicu asselect * from emp;

SQL> create indexjicu_ind_empno on jicu(empno);

1.2插入数据

SQL>  begin                                    

  2  fori in 1..10000 loop

  3 insert into jicu values(7788,'WARD','SALESMAN',7839,sysdate,3000,2000,20);

  4  endloop;

  5  end;

  6  /

SQL>commit;

 

1.3 分析表，查看集簇因子

SQL> analyze table jicuestimate statistics;

SQL>  selectt.table_name,t.NUM_ROWS,t.BLOCKS,t.AVG_ROW_LEN,i.index_name,

  2 i.CLUSTERING_FACTOR from dba_tables t,dba_indexes i

  3  where t.table_name=i.table_name

  4  andt.owner='SCOTT'

  5  andt.table_name='JICU';

1.4 建立柱状图

SQL> execDBMS_STATS.GATHER_TABLE_STATS('SCOTT&#