Clearing pr_sys_ruleset_index and pr_index_reference

General
, , ,
1

HI Team, we are running an out of place upgrade and first step is to migrate rules schema. Seems all the rest of tables get done within an hour but the two tables pr_sys_ruleset_index and pr_index_reference are taking more than 4 hours - they contain 23M+ and 3M+ records respectively

question: Can we simply truncate them before migration to reduce the migrate time. We can use prpcUtils to regenerate index reference table. Will running an upgrade on a ruleschema without these two tables work ok?

2

We truncated the tables and the upgrade went fine, also truncated cache tables post upgrade.

3

@Tanul_Thanvi

FYI: It’s of No harm in performing Truncation about the Tables you have mentioned. Since those Tables are not the actual System Cache Tables, it’ll not be specified on purpose usually. Otheriwse no issue in Truncating the them.