http://www.oracle.com/us/products/database/peoplesoft-partitioning-bwp-068458.pdf
On Thu, Mar 3, 2016 at 7:37 PM, Orlando L <oralrnr@xxxxxxxxx> wrote:
Hi
Our peoplesoft Fin system is getting bigger. Currently we do not have
partitioned tables in there. We are thinking partitioning. Can anyone share
their experiences with partitioning in psft?
I have several questions on
- what to partition by (this probably is the toughest - the tables don't
make any good sense),
- the indexes, esp, the global ones,
- post partition-implementation maintenance,
- query and db performance afterwards, etc.
Does a paper exist for the above. TIA.
Orlando.