Re: Fortnight partitions
Posted by:
Rick James
Date: November 21, 2012 08:54PM
I have no experience with PARTITION BY LIST. Suggest you experiment with a small table. Do EXPLAIN PARTITIONS SELECT... to verify that partition pruning actually works for your queries. (Otherwise, the SELECTs may be slowed down rather than sped up.)
`part_id` seems feasible.
DROP PARTITION is "instantaneous". DELETEing the rows from a large partition is painfully slow.
Subject
Views
Written By
Posted
4183
November 19, 2012 11:24PM
2458
November 20, 2012 10:56PM
1660
November 20, 2012 11:23PM
Re: Fortnight partitions
1769
November 21, 2012 08:54PM
1713
November 23, 2012 12:04AM
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.