RE: Histograms

Hi,

Oracle cannot set the number of buckets greater than the number of distinct values in a column. Smart, isn4t it?

Perhaps your analized column only has 3 distinct values?

HTH         Joselu

> -----Mensaje original-----
> De: djordjej [SMTP:djordjej_at_attcanada.ca]
> Enviado el: miircoles 28 de junio de 2000 3:34
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: Histograms
>
> Hi Arun,
>
> What is the cardinality of the column ? How many rows in the table ?
>
> Djordje
>
> -----Original Message-----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Date: Tuesday, June 27, 2000 6:42 PM
>
>
> >Hi,
> >I am trying to analyze a column using histograms with the bucket size of
> >80,after analyzing when I check the num_bucket from user_tab_columns of
> that
> >analyzed column it is showing as 3.
> >Can somebody tell me what is the probs and how I can solve this issue
> >Thanks in advance
> >arun
> >________________________________________________________________________
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> >--
> >Author: ARUN K C
> > INET: arun_k_c_at_hotmail.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >
>
> --
> Author: djordjej
> INET: djordjej_at_attcanada.ca
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jun 28 2000 - 04:54:18 CDT