dbms_stats and number of buckets
From: Ls Cheng <exriscer_at_gmail.com>
Date: Thu, 19 Oct 2017 10:02:49 +0200
Message-ID: <CAJ2-Qb_jYDca17kOKe+JAiEhSXS63MVFTK90+AckH32PA1LwZA_at_mail.gmail.com>
Hi
Date: Thu, 19 Oct 2017 10:02:49 +0200
Message-ID: <CAJ2-Qb_jYDca17kOKe+JAiEhSXS63MVFTK90+AckH32PA1LwZA_at_mail.gmail.com>
Hi
TABLE_NAME COLUMN_NAME HISTOGRAM NUM_BUCKETS ------------------------------ ------------------------------ --------------- ----------- HL7_PENDING ESTADO FREQUENCY 3
the column is varchar32 and NOT NULL
And the query shows bad cardinality of course. This is RAC 11.2.0.4 with July 217 PSU. Any idea?
Thanks
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 19 2017 - 10:02:49 CEST