I have a single node cluster running Data, Index & Query services. It has a total of 24 vCPUs and there is absolutely nothing running on the cluster, in other words resources are free.
On the CBQ prompt, I set max parallelism to 4 and executed a query.
Since it is a single node cluster (but it does have 24 vCPUs), will it actually use a parallelism of 4 ?
I did not see any visible difference in the execution time. Hence wanted to know if there is a way to check what was the actual parallelism in effect for that execution?
I have a single node cluster running Data, Index & Query services. It has a total of 24 vCPUs and there is absolutely nothing running on the cluster, in other words resources are free.
On the CBQ prompt, I set max parallelism to 4 and executed a query.
Since it is a single node cluster (but it does have 24 vCPUs), will it actually use a parallelism of 4 ?
I did not see any visible difference in the execution time. Hence wanted to know if there is a way to check what was the actual parallelism in effect for that execution?