Re: endpoint_value and endpoint_actual_value

You might like to get the Jonathan Lewis book on the CBO and
carefully go over the chapter on histograms.  He explains it rather well.

http://www.amazon.com/gp/product/1590596366


--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


On 3/16/06, Jerry Brenner <jbrenner@xxxxxxxxxxxxx> wrote:
>
>  We have a tool in our product that displays the database statistics for
> all of the tables in the schema in order to help with remote debugging of
> performance problems.  Right now, we simply list out the contents of a
> histogram in an html table, but we are trying to get to the point of
> including a graphical representation of the histograms that includes the end
> point values.  I'm trying to figure out how to properly decode the values in
> endpoint_value.  Here's what I've come up with so far:
>
>
>
> SELECT h.table_name, h.column_name, data_type, histogram, endpoint_number,
> endpoint_value, endpoint_actual_value,
>

Other related posts: