From asktom
-------------
you can import/export/set statistics directly with dbms_stats
it is easier to automate with dbms_stats (it is procedural, analyze is just a command)
dbms_stats is the stated, preferred method of collecting statisttics.
dbms_stats can analyze external tables, analyze cannot.
DBMS_STATS gathers statistics only for cost-based optimization; it does not gather other
statistics. For example, the table statistics gathered by DBMS_STATS include the number
of rows, number of blocks currently containing data, and average row length but not the
number of chained rows, average free space, or number of unused data blocks.
dbms_stats (in 9i) can gather system stats (new)
ANALYZE calculates global statistics for partitioned tables and indexes instead
of gathering them directly. This can lead to inaccuracies for some statistics, such as
the number of distinct values. DBMS_Stats won't do that.
Most importantly, in the future, ANALYZE will not collect statistics needed by
the cost-based optimizer.
相关文章
- 10-24python 同步与异步的性能区别以及遇到IO阻塞时会自动切换任务
- 10-24性能优化与性能设计,“相亲相爱”的一对
- 10-24SQL 中的 in 与 not in、exists 与 not exists 的区别以及性能分析
- 10-24浅析import与require的基本用法及引入方式区别以及在模块加载时间、模块本质、性能、严格模式、值与引用的5个方面区别
- 10-24Web 性能优化:Preload与Prefetch的使用及在 Chrome 中的优先级
- 10-24Web 性能优化:Preload与Prefetch的使用及在 Chrome 中的优先级
- 10-24《大型网站技术架构演进与性能优化》——第二章:无线化:无线时代下的架构演进
- 10-24《大型网站技术架构演进与性能优化》——第四章:全球化下的网站演进:全球部署方案
- 10-24《大型网站技术架构演进与性能优化》——第七章:链路优化:大秒系统的极致优化思路
- 10-24《大型网站技术架构演进与性能优化》——第九章:网站高可用建设:大型网站的稳定性建设