MySQL Forums
Forum List  »  Partitioning

Which column to use for partitioning
Posted by: chillyroll r
Date: April 15, 2009 08:07AM


I have a table tbl_data which has around 8.4 million records. In this I have 2 columns state_code and city_id. state_code is a CHAR (2) column which stores the 2 char state code like NY, CA and so on. Where as the city_id is a foreign key in this table another table tbl_city. I have around 52 states (no different table for states) and 30000 cities. I want to partition tbl_data. My question is which column should I use for partitioning, state_code or city_id. Also, which partitioning should I go for? I cannot use Range since I dont have city_id in sequence for a single state. I perform a search in my application based on "City, State" string.

Let me know what is the best partitioning policy in my case.


Options: ReplyQuote

Written By
Which column to use for partitioning
April 15, 2009 08:07AM

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.