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

[Richard Sims]

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