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
3177
November 26, 2011 05:41AM
1565
November 26, 2011 12:34PM
1912
November 26, 2011 12:51PM
Re: Data not balanced in partitions
1815
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.