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 11.2.0.3 on a linux machine.

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

=> EXEC DBMS_STATS.COPY_TABLE_STATS(OWNNAME =>'AA',TABNAME =>AA_TABLE,SRCPARTNAME =>'P201302',DSTPARTNAME=>'P201303');

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.

Legend

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