3 Replies Latest reply: Feb 8, 2013 5:16 PM by Satishbabu Gunukula RSS

    can DBMS_STATS.COPY_TABLE_STATS cause index statistics to be NEWLYgatered?

    872581
      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.