网站首页 文章专栏 索引收集
索引收集
编辑时间:2020-04-12 22:40:29.0 作者:hcy 浏览量:41

索引手机

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 
Connected as sxerp

SQL> exec dbms_stats.gather_table_stats(ownname =>'SXERP' ,tabname=>'RECDETAIL' ,estimate_percent => 20,degree => 10,granularity => 'ALL',cascade => TRUE);
 
SQL> exec dbms_stats.gather_table_stats(ownname =>'SXERP' ,tabname=>'RECLIST' ,estimate_percent => 20,degree => 10,granularity => 'ALL',cascade => TRUE);

SQL> exec dbms_stats.gather_table_stats(ownname =>'SXERP' ,tabname=>'PAYMENT' ,estimate_percent => 20,degree => 10,granularity => 'ALL',cascade => TRUE);

SQL> exec dbms_stats.gather_table_stats(ownname =>'SXERP' ,tabname=>'METERINFO' ,estimate_percent => 20,degree => 10,granularity => 'ALL',cascade => TRUE);

SQL> exec dbms_stats.gather_table_stats(ownname =>'SXERP' ,tabname=>'CUSTINFO' ,estimate_percent => 20,degree => 10,granularity => 'ALL',cascade => TRUE);

来说两句吧
最新评论