Skip to Content
0

Maximum parallel queries parameter value scenarios in 4.2SP03

Feb 21, 2017 at 06:29 PM

93

avatar image

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

Thanks

Ram

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers