resource-pool-cpuaffinitymode.md
Specifies whether the resource pool has exclusive or shared use of the CPUs specified in
[CPUAFFINITYSET](#CPUAFFINITYSET):
CPUAFFINITYMODE { SHARED | EXCLUSIVE | ANY }
-
SHARED: Queries that run in this pool share itsCPUAFFINITYSETCPUs with other Vertica resource pools. -
EXCLUSIVE: DedicatesCPUAFFINITYSETCPUs to this resource pool only, and excludes other Vertica resource pools. IfCPUAFFINITYSETis set as a percentage, then that percentage of CPU resources available to Vertica is assigned solely for this resource pool. -
ANY(default): Queries in this resource pool can run on any CPU, invalid ifCPUAFFINITYSETdesignates CPU resources.
Important
CPUAFFINITYMODE and CPUAFFINITYSET must be set together in the same statement.