ADSM-L

Re: Really bad performance for a sql query after upgrading to v 3 .7

2000-11-02 11:50:27
Subject: Re: Really bad performance for a sql query after upgrading to v 3 .7
From: Richard Sims <rbs AT BU DOT EDU>
Date: Thu, 2 Nov 2000 11:49:18 -0500
Mark - Offhand I don't see any APARs relating to your SQL query, so maybe
       you can isolate what the problem might be by using a spectral
approach, doing selects from simple "select * from volumeusage", with
increasing complexity through to your problem select statement.
It may be the Group By or Order By that's generating the overhead, so
isolation will help determine.
  Richard Sims, BU