October 23rd, 2009 by Alberto Dell'Era

As we have seen in the previous posts of this series, in 11g a new figure named “NewDensity” has been introduced as a replacement for the “density” column statistic for columns whose histogram has been collected; this change has been backported in 10.2.0.4 also. In the...

Read morePosted in CBO | 14 comments

October 16th, 2009 by Alberto Dell'Era

In this post we are going to explore and explain the rationale for the formula used by the CBO to compute the “NewDensity” figure that replaces, from 10.2.0.4 onwards, the “density” column statistic in the cardinality estimation formulae for columns with height-balanced (HB)...

Read morePosted in CBO | 7 comments

October 10th, 2009 by Alberto Dell'Era

In this post we are going to explore and explain the rationale for the formula used by dbms_stats to compute the “density” column statistic, used by the CBO in versions less than 10.2.0.4 to estimate the cardinality of a class of SQL statements. In the next post, we will speak about its...

Read morePosted in CBO | 6 comments

October 3rd, 2009 by Alberto Dell'Era

Let’s explore the concept of cardinality from the point of view of the statistician; this is both to get a clearer vision of the matter (i.e. for fun) and to path the way for understanding the rationale for the “density” statistics as calculated by dbms_stats (the topic of an...

Read morePosted in CBO | 3 comments