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.
