question on skew only when collecting histograms
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...