Question

5
Replies
76
Views
Close popover
Wilton Tuji (WiltonT6)
Accenture Brazil

Accenture Brazil
BR
WiltonT6 Member since 2018 2 posts
Accenture Brazil
Posted: January 14, 2020
Last activity: January 21, 2020

Report definition - Parallel hint

Hello!

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