Oracleanalyzetable的使用总结

SQL> analyze table my_table compute statistics;

SQL> analyze table my_table compute statistics for table for all indexes for all columns;

SQL> analyze table my_table compute statistics for table for all indexes for all indexed columns;

SQL> analyze table my_table compute statistics;

等价于：

SQL> analyze table my_table compute statistics for table for all indexes for all columns;

sample:

analyze table t1 compute statistics for table;
analyze table t2 compute statistics for all columns;
analyze table t3 compute statistics for all indexed columns;

analyze table t5 compute statistics for all indexes;

analyze table t4 compute statistics; (不指定）

另外，可以删除分析数据：

SQL> analyze table my_table delete statistics;

SQL> analyze table my_table delete statistics for table for all indexes for all indexed columns;

更多相关教程请访问 MySQL视频教程