[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: PeopleSoft W-2 SQR

I worked with the W-2 process in Houston and experienced similar performance 
issues.  There's dynamic ORDER BY SQL that may be modified.  There are also 
indexes that may be dropped during the INSERT phase. I was able to get the 
process down from the same twenty-five hours to ninety minutes.  Good luck.


HTH,
Steffon Johnson
The Business Systems Professionals, LLC
TheBSPs@aol.com