dbms_stats包的几个用法举例
记录常用的几个，备查
[@more@]SQL> exec dbms_stats.create_stat_table('PVG_WH1_HL','temp_stat');
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.export_table_stats(ownname=>'PVG_WH1_HL',tabname=>'LAGI',STATTAB=>'TEMP_STAT',CASCADE=>TRUE);
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.import_table_stats(ownname=>'PVG_WH1_HL',tabname=>'LAGI',STATTAB=>'TEMP_STAT',CASCADE=>TRUE);
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.LOCK_TABLE_STATS(OWNNAME=>'PVG_WH1_HL', TABNAME=>'LAGI');
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.UNLOCK_TABLE_STATS(OWNNAME=>'PVG_WH1_HL', TABNAME=>'LAGI');
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.gather_table_stats(ownname=>'PVG_WH1_HL',tabname=>'LAGI',estimate_percent=>20,cascade=>true);
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.set_index_stats(OWNNAME=>'PVG_WH1_HL', INDNAME=>'LAGI_COMPLETE_LOCAL', NUMDIST=>1124712);
PL/SQL procedure successfully completed.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30623428/viewspace-1874835/ ，如需转载，请注明出处，否则将追究法律责任。
