Index statistics sample size really small
Hello,
My index statistics on all my oracle databases (11.2.0.4) are very small if I gather them with the AUTO_SAMPLE_SIZE parameter (or using the automatic stat job over night).
In the example, note that I already multiply by 100 so it's not 14% in decimal form, but indeed 0.14% (very sad)
select num_rows,sample_size, case when num_rows=0 then 0 else sample_size/num_rows*100 end sample_percent, last_analyzed from dba_ind_statistics where index_name='PK_DEPOSIT_BATCH_SEQ' and owner=NICO'
num_rows sample size sample_percent last_analyzed
7594362 1080642 0.142295297485161 8/8/2015 1:18:38 PM
exec dbms_stats.gather_index_stats(ownname=>NICO',index_name=>'PK_DEPOSIT_BATCH_SEQ');