best way to gather statistics on partitioned tables and indexes
Hi to all,
i´m a newbie in Oracle and i have some questions about gather statistics on partitioned tables.
We have an Oracle Database 10gR2 in a HP-UX box.
We are in process of partitioning a set of tables and related indexes using DBMS_REDEFINITION.
After partitioning we must gather statistics from the partitioned tables and indexes in order to run properly SPA (Sql Performance Analyzer) and analyze performance after partitioning.
Now we are using DBMS_STAT.GATHER_TABLE_STATS('OWNER','TABLE_NAME', CASCADE => TRUE). In this stage, what would be the best method to gather statistics?
Help will be appreciated.