No of partitions for a QP
Hi Team,
Read in some articles that the no of partitions for a QP by default is 5 from 8.7 version.
Can we still have the maximum partitions as 20?
What is the impact if we keep 5 or 20, Is it that if we have less throughput we should go with 5 and if we have more throughput we should go with 20?
And what will happen if we increase it beyond 20? Looks like it is a global setting and not specific to any QP ? Is there no way that we can have partitions based on the name of QP, like which QP needs better throughput we can make it 20 and other as 5