7. Configuring and Managing VectorH : Performance Tips : Per-query Parallelism Level
 
Share this page                  
Per-query Parallelism Level
An explicit parallelism level can be set for a single query. to test its effect. Use the following syntax:
SELECT...WITH MAX_PARALLEL n
where n is an integer between 1 and 256. The value of n should not exceed the number of CPU cores visible to the operating system.