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?
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.