Posted: 10 Aug 2018 14:38 EDT Last activity: 29 Aug 2018 8:26 EDT
SPPR_PURGE_TABLE table huge time
SPPR_PURGE_TABLE store proc at restart time is taking huge time.
following table has multiple million of record and queries are timeing out since long. DBA is recommending to truncate instead of datatime delete. Can we trauncate following cleanup tables? what will bethe impact?