Re: Partition behaiour seems abnormal in range partition
Posted by:
Rick James
Date: December 20, 2012 02:56PM
Are the partitions of similar size?
To further debug...
SELECT * FROM information_schema.PARTITIONs WHERE table_schema = 'PART_SAMPLE';
(or something like that)
EXPLAIN PARTITIONS SELECT ... -- for a fast partition; then for a slow partition.
You may need to do an OPTIMIZE. Probably only once. Probably it will take a long time (and lock the table).
Subject
Views
Written By
Posted
2934
December 10, 2012 12:05AM
Re: Partition behaiour seems abnormal in range partition
1557
December 20, 2012 02: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.