cleanup old CS data
Anyone has any script to delete the OLD CS unwanted or log data from the database, like below, so we can save some space on DB side and gain performance .
Thank you.
DELETE FROM PS_CALC_MESSAGES WHERE STRM <2078
DELETE FROM PS_SA_REPORT_RSLT WHERE REPORT_REQUEST_NBR < '000275500'
DELETE FROM PS_FORM_DATA_C128 FROM PS_FORM_INSTANCES a,PS_FORM_DATA_C128 b WHERE a.FORM_PROC_INST = b.FORM_PROC_INST AND a.EXPIRATION_DATE < '2007-01-01' ;
DELETE FROM PS_FORM_DATA_C254 FROM PS_FORM_INSTANCES a,PS_FORM_DATA_C254 b WHERE a