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.
Subject
Views
Written By
Posted
What Method is Best
3140
September 12, 2012 03:12PM
1984
September 14, 2012 02:36AM
1782
September 14, 2012 05:30AM
1699
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.