I did not do it with Peoplesoft,
but with a simlar time depenend App where I made such a partitioning. Hope the
concepts do work with PS as well.
Do you Partition by Year of EFFDT ?
Yes, I would. It does keep your buffer cache cleaner by moving old rows to an
older partition
Your estimations are better because of partition stats.
Do you create Locally Prefixed or NonPrefixed Indexes ?
definitely locally NonPrefixd. Do don't want effdt leading an index. Guess you
would be due for all kind of unpleasent surprise, cause the optimizers sees
effdt as very selective.
Lothar
----Ursprüngliche Nachricht----
Von : Hemant-K.Chitale@xxxxxx
Datum : 06/11/2015 - 08:44 (GMT)
An : oracle-l@xxxxxxxxxxxxx
Betreff : PS_RT_RATE_TBL Partitioning
Looking for advice on Partitioning PS_RT_RATE_TBL in Peoplesoft.
Do you Partition by Year of EFFDT ?
Do you create Locally Prefixed or NonPrefixed Indexes ?
Hemant K Chitale
This email and any attachments are confidential and may also be privileged. If
you are not the intended recipient, please delete all copies and notify the
sender immediately. You may wish to refer to the incorporation details of
Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at
https://www.sc.com/en/incorporation-details.html
