sqr using 90% cpu

[Bob Shiflett <shifletb@WLRFOODS.COM>]

We are having a major problem with some of our sqr reports taking up to 90%
of the cpu.  We have run the reports through SQL-LAB and explain.sqr and
they seem to be o.k, No full table scans, using the indexes.  We tried
moving the tables around in the where clause and this seemed to bring one
report in particular to 40% but this is still to high. We are using SQR
V3.0.12.1  on a HP-UX 9000.

Is the problem in the order of the tables in the FROM clause?
Does the  WHERE clause have an effect on machine performance?

Any information will be appreciated.

----------------------------------------------------------------------------
----
Bob Shiflett    : Software Engineer/Analyst
                             WLR Foods, inc.

Internet (Work)         : shifletb@wlrfoods.com
Voice                           : 540.896.0777
Fax                             : 540.896.1012