Lowering SQR Priority

[Thomas McCready <isis@RS10.LOC.GOV>]

> 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


One work-around might be to assign a lower priority on the run command,
assuming you are running SQR as a batch process:

nice -n 15 sqr report.sqr sa/password -VSYBASE

  To:  Bob Shiflett    : Software Engineer/Analyst
      WLR Foods, inc.
  From:  Tom McCready, Library of Congress