DBMS_STATS - Global - daily/monthly partition table performance
DBMS global stats - daily/monthly partition load
What is the best practice to gather global stats on each partition and how frequently?
I have two scenarios in regards to DBMS_stats - global stats, monthly and daily partition.
1) I was running the following dbms_stats on a monthly partition with granularity =>'ALL' and it took 23 minutes, the partition has only one day of data, 125k rows. We load data into this monthly partition everyday and run reports. This November partition will grow to approximately to 8 million rows at the end of the month. We can not afford to run this global stats everyday since it takes 23 minutes.
What is the best practice to gather global stats on each partition and how frequently?
I have two scenarios in regards to DBMS_stats - global stats, monthly and daily partition.
1) I was running the following dbms_stats on a monthly partition with granularity =>'ALL' and it took 23 minutes, the partition has only one day of data, 125k rows. We load data into this monthly partition everyday and run reports. This November partition will grow to approximately to 8 million rows at the end of the month. We can not afford to run this global stats everyday since it takes 23 minutes.
0