Re: Partitioning problem
I think that the partitioning formula must resolve to DAYS, rather than individual hours.
We also discovered something odd that's apparently related. We have a table partitioned by month, but if you do an EXPLAIN PARTITIONS on this statement...
SELECT COUNT(*) FROM foo WHERE CreateDT BETWEEN '2008-08-01' AND '2008-08-31 23:59:59';
... you'll find that it accesses BOTH the 200808 partition AND the 200809 partition. As near as I can tell, this is because the second limit rounds to '2008-09-01', which falls in the later partition. Nevertheless, this is certainly not the expected or desired outcome.
Subject
Views
Written By
Posted
5130
August 31, 2008 03:49AM
Re: Partitioning problem
2454
September 04, 2008 12:19PM
2535
September 06, 2008 01:17PM
2370
October 08, 2008 08:00AM
2251
October 08, 2008 10:56PM
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.