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?

      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.