cancel
Showing results for 
Search instead for 
Did you mean: 

Does priority = 'Background' turn off intra-query parallelism?

10-07-2018 5:00 PM
Breck_Carter Participant
2051 views 1 comments
0 Likes
SAP Managed Tags
Subscribe

The Watcom Rule would imply "Intra-query parallelism is not used for connections with priority set to Background"... is that true?

The Help for the old background_priority option [deprecated] says "Intra-query parallelism is not used for connections with background_priority set to On".

However, the Help for the new priority option makes no such claim for SET TEMPORARY OPTION priority = 'Background'.

0 Likes

Accepted Solutions (0)

Answers (1)

Answers (1)

VolkerBarth
Contributor
0 Likes

I have justed noted that the docs do tell about that, I have not checked reality:)

From the v17 "Parallelism in queries" topic:

Following is a list of circumstances in which a query cannot take advantage of parallelism, either at optimization or execution time:
* the server computer does not have multiple processors
* [...]
* the priority option is set to background

Makes sense, particularly as the deprecated Background_priority option is implemented as setting the priority option to 'Background'...