Question
7
Replies
259
Views
CSC
Posted: June 21, 2016
Last activity: June 22, 2016
Closed
DB length growing over a period of time, especially the TCH_work table. Is there any approach/suggestions from Pega?
DB length growing over a period of time, especially the TCH_work table. Is there any approach/suggestions from Pega?
Posted: 4 years ago
Hi Arvind,
Table Size in MB :
| 300216 |
NO OF RECORDS :
| 16608223 |
Purge and archive wizard which you have suggested is not applicable for us.At any point of time users want to work on any closed claim and reopen them.
Posted: 4 years ago
Kindly provide us if any other approaches are available to overcome this issue.
Posted: 4 years ago
No of records are high.
You can involve DBA to introduce better Indexing on this table.
Hope that helps
Posted: 4 years ago
Hi Arvind,
Thank you for early response.
Please provide if we have any recommendations from PEGA.
Posted: 4 years ago
Hi Seshaiah,
In such cases, we suggest to consult database administrator to introduce Indexing that helps in scanning the table faster.
Hi Seshaiah,
Samuel raised same question here, DB length growing over a period of time, especially the TCH_work table. Is there any approach/suggestions from Pega?
Do let us know the number of records this table contains.