This discussion is archived
3 Replies Latest reply: Feb 8, 2013 3:16 PM by Satishbabu Gunukula RSS

can DBMS_STATS.COPY_TABLE_STATS cause index statistics to be NEWLYgatered?

872581 Newbie
Currently Being Moderated
Hi, all

The db is on a linux machine.

In my production db, I issued the follwoing command in order to copy table/index statistics between partitions.


Can the above command cause index statistics to be "NEWLY" gathered instead of copying table/index statistics?
After I issued the command, some of index partitions'statistics are newly gathered (last_analyzed ).

I am still not sure that the two things are between cause-and-effect relationship.

Thanks in advance.
Best Regards.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points