RE: Statistics Problem on partitioned table
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 1 Oct 2013 15:22:18 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DB9C1D_at_exmbx05.thus.corp>
Date: Tue, 1 Oct 2013 15:22:18 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DB9C1D_at_exmbx05.thus.corp>
Mohamed,
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 ?
Regards
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--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 01 2013 - 17:22:18 CEST