Sign in to Community
Sign in to view all badges
When we try to run any query against broadlog RCP table, we always see that the data retrieval is very slow, for example :-
above is the only query to read the data from the broadlogRCP table, which takes long hours to get the data and sometimes even times out.
We also have checked if there are any parallel jobs running on the same table or any other through the query monitoring, but did not see any except this workflow.
Since it is Adobe Hosted environment we are not able to see the logs properly.
I was just wondering should this table be optimized or analysed before we start the run the query activity.
I tried the way you mentioned but the result is still the same, the workflow is still running now.