MySQL Forums
Forum List  »  Partitioning

partitioning with date
Posted by: Jacob Joseph
Date: February 24, 2009 08:15AM

Hi ,

I had partitioned a table with range partition having the expression 'year(datetime)' also sub partitioned each main partition with a hash partition having expression 'month(datetime)' and tried to access the data in the same table using a select query having a where condition of date range of one year ,the time taken to execute the query is more as compared to the query execution time in another table with same data and having no partition ,also the primary key of the both table are same.

I think partition increases the execution speed of query ,but unfortunately i couldn't achieve it from the above experiment.Is there anything more i have to do in partitioning other than giving the range value and hash values properly . Can anybody help me out in this regard.

Thank You,
Regards
jacob

Options: ReplyQuote


Subject
Views
Written By
Posted
partitioning with date
3700
February 24, 2009 08:15AM
2309
March 18, 2009 09:19AM


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.