Sqlt mentions that statistics are stale (not gathering) from 2011- Peoplesoft Best Practices stats a

PeopleTools version 8.47.14 - Gathering statistics following Best practices.Running sqlt latest for a query indicated that an index has not being gathered statistics since 2011.

Is the best practice script wrong?

Then why this index statistics are not being gathered?

This is being gathered every Sunday:

SQL> select table_name, partition_name, sysdate, last_analyzed, stale_stats, num_rows

  2   from dba_ind_statistics where index_name ='PSCPSAPMSGPUBHDR';

 

TABLE_NAME                     PARTITION_NAME                 SYSDATE

------------------------------ ------------------------------ ---------

LAST_ANAL STA   NUM_ROWS

--------- --- ----------

PSAPMSGPUBHDR                                                 11-JUN-13

29-JUL-11 YES      44597

 

 

SQL> select table_name, partition_name, sysdate, last_analyzed, stale_stats, num_rows

  2  from dba_tab_statistics