Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Lucas Santana (LucasS90)
IDMO Group

IDMO Group
BR
LucasS90 Member since 2017 1 post
IDMO Group
Posted: Oct 15, 2021
Last activity: Oct 18, 2021
Posted: 15 Oct 2021 11:05 EDT
Last activity: 18 Oct 2021 12:38 EDT
Closed

PEGA0005 for table pegadata.pr_data_ih_fact.

Hello,

We have been receiving alerts like "PEGA0005" about the execution time of a native query that queries the table "pegadata.pr_data_ih_fact". Currently this table has 6,207,220 records.

Is there any kind of maintenance that can be done on this table besides rebuilding the indexes? Can we delete old records without compromising the operation of the tool?

***Edited by Moderator: Pooja Gadige to add capability tag***
To see attachments, please log in.
Pega Platform
Decision Management
System Administration

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice