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

[Breck_Carter]

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'.

[VolkerBarth]

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'...