Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Histograms

Re: Histograms

From: djordjej <djordjej_at_attcanada.ca>
Date: Tue, 27 Jun 2000 20:27:56 -0400
Message-Id: <10541.110606@fatcity.com>


Hi Arun,

What is the cardinality of the column ? How many rows in the table ?

Djordje

-----Original Message-----
From: ARUN K C <arun_k_c_at_hotmail.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Tuesday, June 27, 2000 6:42 PM
Subject: Histograms

>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).
Received on Tue Jun 27 2000 - 19:27:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US