MySQL Forums :: Partitioning :: What Method is Best


Advanced Search

What Method is Best
Posted by: Larry Adams ()
Date: September 12, 2012 03:12PM

Hi forum. I have a partitioned table that receives queries based upon a range between two different date fields. Those date fields are:

startTime TIMESTAMP
endTime TIMESTAMP

I would like to deploy RANGE type partitioning based upon endTime, that much is a no-brainer. However, when I perform a query as follows:

WHERE startTime BETWEEN 'A' AND 'B' OR endTime BETWEEN 'B' AND 'C'

I would like the partition to know about the startTime ranges in my various partitions, so that the pruning algorythim does not have to perform a full scan of all partitions.

I don't think the answer is sub partitions. Please let me know your thoughts.

TheWitness



Edited 1 time(s). Last edit at 09/12/2012 03:14PM by Larry Adams.

Options: ReplyQuote


Subject Views Written By Posted
What Method is Best 2029 Larry Adams 09/12/2012 03:12PM
Re: What Method is Best 1321 Mattias Jonsson 09/14/2012 02:36AM
Re: What Method is Best 1232 Larry Adams 09/14/2012 05:30AM
Re: What Method is Best 1148 Rick James 09/14/2012 11:11PM


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.