Hi all,
I want to use DBMS_STATS to gather column value histograms, but it seems that there's a maximum number of buckets allowed - around 250 I think. Is this the case or am I missing some syntax?
What I want to do is run the histograms so I can get the distinct values available for a given column, so I want to input as the number of buckets to be the number of rows of the table.
Any help is appreciated,
Ron
I want to use DBMS_STATS to gather column value histograms, but it seems that there's a maximum number of buckets allowed - around 250 I think. Is this the case or am I missing some syntax?
What I want to do is run the histograms so I can get the distinct values available for a given column, so I want to input as the number of buckets to be the number of rows of the table.
Any help is appreciated,
Ron