analyze table unrated_usage.ft_unrated_usage_o compute statistics;For one given partition:
analyze table unrated_usage.ft_unrated_usage_o partition(P0) compute statistics;
analyze table unrated_usage.ft_unrated_usage_o compute statistics;For one given partition:
analyze table unrated_usage.ft_unrated_usage_o partition(P0) compute statistics;
SELECT table_name, partition_name, high_value, num_rows FROM SYS.ALL_TAB_PARTITIONS where table_name = 'SMSC_CDR_MT' and num_rows != 0 ORDER BY partition_name;