创建或重建索引时强制收集统计信息 

SQL> col KSPPINM format a30
SQL> col ksppstvl format a20
SQL> col ksppdesc format a60
SQL> set line 200
SQL> SELECT   ksppinm, ksppstvl, ksppdesc  
  2  FROM   x$ksppi x, x$ksppcv y  
  3  WHERE   x.indx = y.indx AND  ksppinm = '_optimizer_compute_index_stats'; 

KSPPINM                        KSPPSTVL             KSPPDESC
------------------------------ -------------------- ------------------------------------------------------------
_optimizer_compute_index_stats TRUE                 force index stats collection on index creation/rebuild

SQL>

 

posted @ 2018-02-02 13:45  PoleStar  阅读(231)  评论(0)  编辑  收藏  举报