Discussion
2
Replies
253
Views
Cognizant Technology Solutions
Posted: May 13, 2016
Last activity: April 6, 2018
Closed
DB issue after upgrading to Pega 7.2
A 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.
Did you run the rebuild indexes stored procedure after the upgrade?. This is one of the root cause for slow running query.