One of our jobs that consist AE was taking 10 minutes earlier and now a days it is taking 35 +minutes to get completed.
The SQL it is getting stuck at "ANALYZE TABLE %Table(REC1_TAO) COMPUTE STATISTICS".
Can you let me know what I can do to tune SQL and performance?
We have tried to use %UpdateStats(REC1_TAO,high) but not working, tried to check Indexing aswell no luck.
PS ver 8.9
|Peoplesoft Web PIA installation||PeopleSoft Technical||03/15/2017 - 2:20am|
|Populate Multiple Grids on a same Page with diff output based on conditions.||PeopleSoft Technical||03/04/2017 - 1:35pm|
|Updating a row using Peoplecode - Component Interface.||PeopleSoft Technical||02/21/2017 - 11:26pm|
|To load CSV file data into staging table without using file layout||PeopleSoft Technical||01/15/2017 - 8:31am|