Discussion2Replies251Views SudhanshuS5799 Member since 2014 4 posts Cognizant Technology Solutions Posted: 4 years agoLast activity: 4 years 4 months ago Closed DB issue after upgrading to Pega 7.2A long query of approx 5500 lines is running on pr_index_reference table after upgrade which makes the server very slow.What could be the reason?**Moderation Team has archived post**This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post. Low-Code App Development Upgrades ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion. Posted: 4 years agoearvd PEGA replied to SudhanshuS5799Did you run the rebuild indexes stored procedure after the upgrade?. This is one of the root cause for slow running query. Posted: 4 years agoUpdated: 4 years agoVigneshAravind Cognizant replied to SudhanshuS5799Run RULES_SCHEMA.SPPR_REBUILD_INDEXES to rebuild the indexes. After this verify the PegaAlertLogs for any alerts from pr_index_reference table. Please let us know if this helped.