Question

2
Replies
799
Views
Close popover
Errol Tocson (ErrolJanT)
Bank of America
SVP, Apps Programming Exec
Bank of America
US
ErrolJanT Member since 2013 1 post
Bank of America
Posted: March 16, 2017
Last activity: March 24, 2017
Closed

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***

Data Integration
Moderation Team has archived post