RE: Statistics Problem on partitioned table

From: Jonathan Lewis <>
Date: Tue, 1 Oct 2013 15:22:18 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DB9C1D_at_exmbx05.thus.corp>


How come there is only one distinct value of per_ind (first post), but the number of distinct keys in the index on per_ind is over 700,000 ?

Jonathan Lewis  

select leaf_blocks, distinct_keys, clustering_factor, num_rows,partitioned

from all_indexes where index_name = 'XXX_PER_IND';

leaf_blocks distinct_keys clustering_factor num_rows partitioned

119369      721701            204870                 49754928  YES

There is only one distinct value of per_ind (per_ind =0)

select per_ind, count(1) from XXX_PER_YYY group by per_ind;

*per_ind cout(1)*

0 6,118,184-- Received on Tue Oct 01 2013 - 17:22:18 CEST

Original text of this message