[11gR2] : user_tab_partitions.num_rows vs user_tables.num_rows for partitioned tables

Hi,

We have only partitioned tables and we use user fixed statistics to have best performances.

NUMS_ROWS is provided only at partition level and NOT at table level (NULL) : is it good to do so ?

We use 3 tables to store fixed user statistics.

Are these metrics enough for 11g optimizer after upgrading 10g/11g?

Should we add table NUM_ROWS in addition to partition NUM_ROWS?

SQL> desc TAB_METRICS

Name          Type         Nullable Default Comments

------------- ------------ -------- ------- --------

TABLE_NAME    VARCHAR2(30)                           

NUM_ROWS      NUMBER       Y                        

BLOCKS        NUMBER       Y                        

AVG_ROW_LEN   NUMBER       Y                        

LAST_ANALYZED DATE         Y