Question
7
Replies
259
Views
CSC
Posted: 4 years ago
Last activity: 4 years 4 months ago
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
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.
Posted: 4 years ago
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.