11g收集多列统计信息
========================
SQL> exec dbms_stats.gather_table_stats(null,'aa',method_opt=>'for columns (id,name) size skewonly')
PL/SQL procedure successfully completed.
--查询已经创建的多列统计信息
SQL> select extension_name,extension from user_stat_extensions;
EXTENSION_NAME EXTENSION
-------------------- ------------------------------
SYS_STUIA0V924QODN5R ("ID","NAME")
--删除多列统计信息
SQL> exec dbms_stats.drop_extended_stats(null,'aa','(id,name)')
PL/SQL procedure successfully completed.
SQL> select extension_name,extension from user_stat_extensions;
no rows selected
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13177610/viewspace-712338/ ，如需转载，请注明出处，否则将追究法律责任。
