MySQL Forums
Forum List  »  Partitioning

Re: copying from unpartitioned to partitioned table
Posted by: Rick Casey
Date: March 12, 2010 10:58AM

Thanks for this reply.

To answer your question, we need to query this table for specific phonenumber data; so I see your point about not casting phonenumber as an integer.

Fortunately, none of the phonenumbers have any characters other than numbers; but there are numbers with leading zeros. (At least, I hope so; haven't seen every record in this 430MM+ record table.)

I will try to use the KEY method of partitioning.

One other question: will partitioning help speed up index building?

Options: ReplyQuote

Written By
Re: copying from unpartitioned to partitioned table
March 12, 2010 10:58AM

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.