Skip to Content
Feb 21, 2017 at 06:29 PM

Maximum parallel queries parameter value scenarios in 4.2SP03

552 Views Last edit Feb 21, 2017 at 06:31 PM 2 rev

Hello All,

Please let me know the solution for below few queries .

1.The default maximum parallel queries parameter value is 4 , but If our webI report contains five tabs/five queries , how parallel query execution works in database end ? Are queries run in parallel or serial ?

2.The default maximum parallel queries parameter value is 20 but CMC web intelligence processing server 'Max. parallel queries parameter is 10 , in this case ,which parameter value will prefer and execute ?

3.End user wants to see ,where exactly parallel query execution happens that means ,If end user asks ,where do we check parallel query execution on the database or some where ? Is there any tool to check this like data federation tool.

Please do the needful