Question about Column data...

I found that histograms tell the cost based optimizer how the data is distributed within a column (meaning what percentage of rows in a table have a certain value within a column). I also found out which dictionary views are being used to hold histogram information:

DBA_HISTOGRAMS, USER_TAB_COLUMNS (maybe some others as well)

Now, can anyone tell me how do I query these views to find out myself what the data distribution in a column is? I looked at the views, read some books and found nothing helpful so far.

Thank you!

Sergey

In article <8nhvgq$6oe$1_at_nnrp1.deja.com>,   sergey_s_at_my-deja.com wrote:
> How can I find out how the values in a column are distributed? Say
 there
> are two values in a column. I would like to know how many rows would
 be
> returned if I constrained on one value or the other. The table is huge
> so count will take forever, is there a view I can query?
>
> Thank you!
>
> Sergey
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 25 2000 - 09:12:10 CDT