MySQL Forums
Forum List  »  Partitioning

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

Hi,

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?

Thanks,
Naveen

Options: ReplyQuote


Subject
Views
Written By
Posted
Optimum partition for a bigger table
2152
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.