ITPub博客

首页 > IT职业 > IT生活 > 柱状图和列统计信息的关系

柱状图和列统计信息的关系

原创 IT生活 作者:warehouse 时间:2013-06-03 22:08:09 0 删除 编辑

Histograms是Column Statistics的一部分

有关柱状图更详细的信息可以参考性能优化向导中对应的章节:http://docs.oracle.com/cd/E11882_01/server.112/e16638/stats.htm#PFGRF94724

[@more@]

Column Statistics and Histograms

When gathering statistics on a table, DBMS_STATS gathers information about the data distribution of the columns within the table. The most basic information about the data distribution is the maximum value and minimum value of the column. However, this level of statistics may be insufficient for the optimizer's needs if the data within the column is skewed. For skewed data distributions, histograms can also be created as part of the column statistics to describe the data distribution of a given column. Histograms are described in more details in "Viewing Histograms".

Histograms are specified using the METHOD_OPT argument of the DBMS_STATS gathering procedures. Oracle recommends setting the METHOD_OPT to FOR ALL COLUMNS SIZE AUTO. With this setting, Oracle Database automatically determines which columns require histograms and the number of buckets (size) of each histogram. You can also manually specify which columns should have histograms and the size of each histogram.

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

请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    717
  • 访问量
    5098789