ITPub博客

Oracle学习系列—数据库优化—Statistics Summary

原创 Oracle 作者:PercyWang 时间:2007-04-21 17:46:17 0 删除 编辑
关于统计中表字段索引所搜集的相关信息有那些....[@more@]

Statistics generated include the following:

n Table statistics

Number of rows

Number of blocks

Average row length

n Column statistics

Number of distinct values (NDV) in column

Number of nulls in column

Data distribution (histogram)

n Index statistics

Number of leaf blocks

Levels

Clustering factor

n System statistics

I/O performance and utilization

CPU performance and utilization

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8128313/viewspace-911827/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    127
  • 访问量
    1751111