Re: Using hash to partition
Yes, that should work. The only issue might be that, if the table already contains a lot of data, it could take some time for the rows to be re-allocated to the new partitions.
BTW,
PARTITION BY KEY() with no column specified will work if the table has a primary key or unique key; if it doesn't, then you need to specify the column.
Jon Stephens
MySQL Documentation Team @ Oracle
MySQL Dev Zone
MySQL Server Documentation
Oracle
Subject
Views
Written By
Posted
4850
June 04, 2007 05:17AM
3004
June 14, 2007 03:53PM
2811
July 04, 2007 07:09AM
Re: Using hash to partition
2809
July 05, 2007 02:50AM
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.