1 | analyze table unrated_usage.ft_unrated_usage_o compute statistics; |
1 | analyze table unrated_usage.ft_unrated_usage_o partition(P0) compute statistics; |
1 | analyze table unrated_usage.ft_unrated_usage_o compute statistics; |
1 | analyze table unrated_usage.ft_unrated_usage_o partition(P0) compute statistics; |
1 2 3 4 5 6 7 8 | 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; |