List or Range Partitioning
Posted on 2011-04-27
Every month a flatfile approx 500mb will be loaded into a Finance Oracle Datamart via Informatica. The requirements are to keep 24 periods of data. I would have said Range partitioning was the best Partitionign strategy but one could also have List as P1,P2,P3 etc. Ive written a SP to accomodate both but wonder what would be the best strategy ?