Question

5
Replies
834
Views
BHUSHANPATIL Member since 2008 47 posts
Cognizant Technology Solutions
Posted: 2 years ago
Last activity: 2 years 1 month ago
Closed

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?

PR_LOG_REPORTSTATS

pr_perf_stats

pr4_log_rule_usage

pr4_log_rule_usage_details

System Administration Low-Code App Development Installation and Deployment Data Integration
Moderation Team has archived post
Share this page LinkedIn