Posted: 13 Jun 2020 13:15 EDT Last activity: 16 Jun 2020 7:48 EDT
PEGA0005 Alerts in Production
There is PEGA0005 alert in production for a report definition ,which is simple select query with 3 where clause.All the columns are exposed and indexing also done in the table .still its generating alert .what would be the next step to check.
***Edited by Moderator: Pallavi to update platform capability tags***
As stated above, the default threshold for 0005 alerts is 500 ms. This may not be excessive for a given query, depending on how many records are in the table. It depends on the expectation for the given query. Unfortunately, you cannot set specific thresholds for different reports.
Check the actual times for the query and determine if they actually are excessive. If you determine that they are, adn simple indexing is not sufficient, then you may need to implement a compound index involving multiple columns from the WHERE clauses.