MySQL Forums
Forum List  »  Partitioning

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
2995
September 12, 2012 03:12PM
1914
September 14, 2012 02:36AM
1713
September 14, 2012 05:30AM
1620
September 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.