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: Histogram Q

Re: Histogram Q

From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Wed, 13 Dec 2006 11:29:41 -0600
Message-ID: <7b8774110612130929h761518edwf749cf8202b5efdc@mail.gmail.com>


Be careful with that. It is possible to have a height-balanced histogram with one bucket, according some of those views. Granted, it is not really a histogram at all, but the views have some funky logic in them.

On 12/13/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> You are correct - 1 bucket = "no histogram". You can also query for
> user_tab_columns.histogram = 'NONE' to confirm.
>
> Regards,
> Brandon
>
>
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

-- 
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 13 2006 - 11:29:41 CST

Original text of this message

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