windows-1252?Q52=65=3A=76=39=2E=34=30=66=63=39=20=

Posted in 2007

ART KAGEL, — Fri, 09 Nov 2007 14:04:53 — source: IIUG Forums & Mailing Lists

Did you drop and recreate the data distributions after the upgrade? Always a good idea. Once that's complete recompile all stored procedures with UPDATE STATISTICS FOR ROUTINE... Then try testing again. Art S. Kagel ----- Original Message ----- From: Peter_Logan@spartanstores.com <ids@iiug.org> To: ids@iiug.org At: 11/09 6:13:36 Hi all ... I recently upgraded a PeopleSoft database from v9.40fc8 to v9.40fc9. Same hardware ... RS6000 Aix 5.32 ... I seem to be experiencing really long query times on tables that have a bunch of data deleted and reloaded ... I can fix the problem by doing a alter fragment on table ... init in xxx; Anyone seen this behaviour in v9.40fc9? Thanks in advance ... Peter ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.