MySQL Forums
Forum List  »  Partitioning

Re: Using hash to partition
Posted by: Yonder Yonder
Date: July 04, 2007 07:09AM

Thanks for your reply. I decided to go with key() partitions 150. I just need to know if it's possible to alter the hashing function and alter the table under a partitioned table? What will happen with the existing entries? Will they be rehashed? What would the syntax be? alter table 'table' partition by key() partitions 150?

Options: ReplyQuote


Subject
Views
Written By
Posted
4844
June 04, 2007 05:17AM
3000
June 14, 2007 03:53PM
Re: Using hash to partition
2805
July 04, 2007 07:09AM
2806
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.