MySQL Forums
Forum List  »  Partitioning

Optimum partition for a bigger table
Posted by: Jaineera Naveen
Date: July 09, 2015 12:35AM


I am a MS SQL programmer, very new to MySQL.
I have a table of around 45,662,269 rows having a primary key on ID column. Almost all the queries on this table gets filtered by BusNumber (varchar) & UpdateTime (int) columns. Query is taking very long time. Index exists on both the columns.
I would like to create a partitioned table in order to reslove this issue.
Guys, can you please suggest, how to create a optimal partition table?


Options: ReplyQuote

Written By
Optimum partition for a bigger table
July 09, 2015 12:35AM

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.