Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Partitioned table querying is late.

Status
Not open for further replies.

goodmans

MIS
Apr 23, 2008
63
GB
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top