Re: PS_RT_RATE_TBL Partitioning
From: <l.flatz_at_bluewin.ch>
Date: Fri, 06 Nov 2015 07:56:45 +0000
Message-ID: <16923752.6284.1446796605058.JavaMail.webmail_at_bluewin.ch>
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_at_sc.com
Datum : 06/11/2015 - 08:44 (GMT)
An : oracle-l_at_freelists.org
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
Date: Fri, 06 Nov 2015 07:56:45 +0000
Message-ID: <16923752.6284.1446796605058.JavaMail.webmail_at_bluewin.ch>
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_at_sc.com
Datum : 06/11/2015 - 08:44 (GMT)
An : oracle-l_at_freelists.org
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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 06 2015 - 08:56:45 CET