ErrolJanT Member since 2013 1 post
Bank of America
Posted: 3 years ago
Last activity: 3 years 6 months ago

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
Share this page LinkedIn