SQL Performance (MOSC)

MOSC Banner

Index statistics sample size really small

edited Oct 6, 2015 12:19PM in SQL Performance (MOSC) 5 commentsAnswered ✓

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');
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center