I have a table which is partitioned by group_code (that has 7 distinct values)
All 7 partitions have nearly 4million rows. All partitions are on the same tablespace.
When I am querying all the partitiones in parallel 7 queries. few 3 partititons throughput is above 500 p/sec and remaining queries are very slow like 10 p/sec.
What could be the reason. Table is analyzed by 13%. Performance is same when it was analyzed by 40%
Help is very much appreciated.
Regds,
G
All 7 partitions have nearly 4million rows. All partitions are on the same tablespace.
When I am querying all the partitiones in parallel 7 queries. few 3 partititons throughput is above 500 p/sec and remaining queries are very slow like 10 p/sec.
What could be the reason. Table is analyzed by 13%. Performance is same when it was analyzed by 40%
Help is very much appreciated.
Regds,
G