分别收集表、索引的信息 - Oracle-fans - 博客园

​

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.