Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

question on skew only when collecting histograms

user353062Jan 10 2013 — edited Jan 10 2013
I have a table with a column that contains only two distinct values..

country_ID COUNT(*)
---------- ----------
12 645
16 1032
1 2336096

Here i tried collecting the statistics on this table using the following statements:
exec dbms_stats.gather_Table_stats(ownname=>'VISHNU',tabname=>'TEMP1',estimate_percent=>100,degree=>16,method_opt=>'for columns size skewonly');


select table_name,column_name,LAST_ANALYZED,NUM_BUCKETS from dba_tab_col_statistics where owner='VISHNU' and table_name='TEMP1'
/

Here the data appears to be highly skewed an even after trying to specify METHOD_OPT the histograms are not collected on any of the columns in the table.

Is this the default behavior or my understanding of the histograms **For columns size skewonly** or skewness is completly wrong.
can any one please help me in this...

thanks,
Violet...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2013
Added on Jan 10 2013
3 comments
491 views