Partitioning Strategies for P6 Reporting Database
- by Jeffrey McDaniel
Prior to P6 Reporting Database version 3.2 sp1 range partitioning was used. This was applied only to the history tables. The ranges were defined during installation and additional ranges would need
to be added once your date range entered the final defined range.
As of P6 Reporting Database version 3.2 sp1, interval partitioning was implemented. Interval partitioning was applied to the existing History table as well as Slowly Changing Dimension tables. One of the major advantages of interval partitioning is there is no more manual addition of ranges. The interval partitioning will
automatically create partitions for the defined interval when data is inserted into the table and it exceeds the existing partitions.
In 3.2 sp1 there are steps on how to update your partitioning. For all versions after 3.2 sp1 interval partitioning is the only partitioning option used. When upgrading it is important to
be aware of these changes. Here is a link with more information on partitioning -the types and the advantages.
http://docs.oracle.com/cd/E11882_01/server.112/e25523/partition.htm