Delete rows in pr_sys_ruleset_index
Can I just delete rows or truncate pr_sys_ruleset_index without any issues?
We're encountering table space issues in our environment and the DBA can no longer extend the table space. It turns out pr_sys_ruleset_index is using more than half of the table space for our RULES schema. I've read some of the topics about this table and the usual root cause is due to this table usually doesn't have a PK defined and the data is duplicating. However our DBA has confirmed that this table has a PK and it doesn't have duplicates. I'm thinking if it's ok to truncate this table and just rebuild the index.
***Updated by moderator: Lochan to add Categories***
Pegasystems
US
Does this related post help: https://community.pega.com/support/support-articles/prsysrulesetindex-table-growing-exponentially
Bank of America
US
Our space issue was resolved when the DBAs did a DB REORG on 4 development schemas including the schema of the impacted environment. After the REORG, they were then able to extend the tablespace. I was advised by our LSAs not to truncate the rows since it would significantly slow down the environment.