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
