分别收集表、索引的信息

 
SQL> exec dbms_stats.gather_table_stats('DZFPMX','TEST02');
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.gather_table_stats('DZFPMX','TEST02','P02');
PL/SQL procedure successfully completed.
posted @ 2017-10-26 10:39  Oracle-fans  阅读(407)  评论(0编辑  收藏  举报