Using the stats gather statement in peoplesoft peoplecode.



EXEC DBMS_STATS.gather_table_stats('SYSADM', 'PS_LAC_CLS_TBL', estimate_percent => 5, cascade => TRUE);

Here PS_LAC_CLS_TBL is the Peoplesoft Table.


Comments