MySQL Forums :: Partitioning :: Optimum partition for a bigger table


Advanced Search

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 1223 Jaineera Naveen 07/09/2015 12:35AM
Re: Optimum partition for a bigger table 718 Rick James 07/09/2015 11:36PM


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.