Re: partition and subpartitioning help
Is this your only query?
select * from data where timestamp>='...' and timesatmp<='...'
If so, PARTITION buys you nothing. A plain table with an INDEX starting with timestamp will suffice.
As for the Handler_% questions -- which query was that for? How many rows were in the resultset?
Did you realize you are reaching into an extra partition unnecessarily?
timesatmp<='2009-09-02'
-->
timesatmp<'2009-09-02'
(The classic "midnight bug".)
You have not said what the rest of the CREATE TABLE looks like -- are there UNIQUE keys? Is id AUTO_INCREMENT? Etc.
Subject
Views
Written By
Posted
4120
May 11, 2011 04:01AM
1666
May 12, 2011 10:45PM
1761
May 18, 2011 06:13AM
1843
May 18, 2011 06:26AM
Re: partition and subpartitioning help
1666
May 18, 2011 11:15PM
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.