WiltonT6 Member since 2018 2 posts
Accenture Brazil
Posted: 8 months ago
Last activity: 7 months 4 weeks ago

Report definition - Parallel hint


I have a report definition which is taking a very long processing time. We managed to extract the SQL which the report definition is performing and handled to our DBA team to analyse it. Their response is:

  • The query will not be improved with indexes.
  • Add PARALLEL hint in the query in order to increase the performance (it will increase the CPU usage).

Anyone here implemented the "PARALLEL" hint in the query performed by the Report Definition? Can Pega handle it?

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Reporting
Share this page LinkedIn