is it possible to copy the stats? - YES >> DBMS_STATS >> COPY_TABLE_STATS

While working in data integration project, I got the opportunity to tackle very large 2-Level partition tables. Here we have to add partition or I could say at granular level, sub-partition on every week-end. Moderately these partitions and subpartions get loaded with heaps of structured data.

Ah…at this stage we need to take care of table statistics. Most diffcult part is when, which can suit to user’s query. Its been very long time I felt need why we can’t copy the stats which is already genearted for some partitions to another partition?

Now the answer is YES.

DBMS_STATS.COPY_TABLE_STATS………..with this new feature in 11g it is possible.

I was going through several tech article but at below link one can find the best usability of this.

http://oracledoug.com/serendipity/index.php?/archives/1596-Statistics-on-Partitioned-Tables-Part-6a-COPY_TABLE_STATS.html

This is best explained with in-lined examples

enjoy!!

About these ads