Re: Data not balanced in partitions
Posted by:
Rick James
Date: November 28, 2011 11:25AM
PARTITION BY KEY uses a very simple hash. Even if the key is random enough, the partitions will rarely be "perfectly" balanced.
How many rows do you expect when the table is filled?
Why do this PARTITIONing? This is a serious question. I can't think of any performance benefit. I can't think of any coding benefit. Or any other benefit.
Subject
Views
Written By
Posted
2957
November 26, 2011 05:41AM
1465
November 26, 2011 12:34PM
1805
November 26, 2011 12:51PM
Re: Data not balanced in partitions
1704
November 28, 2011 11:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.