Performance Tuning

[John Milardovic <milardj@SX.COM>]

Hi everyone.

The list seems fairly slow right now and I thought it might be a good time
to elicit some opinions/preferences for tuning SQR reports and/or general
rules to follow when designing the reports.  I did a search on the archive
and found some tips/general rules but they were basically rehashing the same
concepts found in the User manual I guess I'm more interested in
solutions/tips that people have come up with themselves through trial and
error.

I recall someone mentioning that they designed all their sql in a third
party app and then after it was tuned they would paste it into SQR.  Is this
a fairly common method?  Does everyone (Oracle users) run explain plan and
tkprof on their sql statements?  When is it better to place select
statements in a stored procedure?  What are people's preferences regarding
nested selects vs. joins (I received some feedback on this a month or so ago
but would like to hear other opinions)?  What switches do people ALWAYS tend
to use? etc. etc.

Also is there any progress on the idea of developing an SQRUG FAQ (Ray had
mentioned something about FAQ-A-Matic (sic?)?

Thanks
John Milardovic