What is Performance tuning of SQR?
- 3 Answers
- 8783 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naresh
Performance tunning can be done with Loadlookup,using with
arrays,cross tabular reports,multiple reports,running on
server
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sridevi bandi
simplify complex select statements.we can use load-lookup
to simplify joins.use dynamic sql instead of a condition in
a select statement.one program can create multiple reports
simultaneously.we can save compiled programs and return
them with sqr execute.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / ravi kumar garre
If u r Creating multiple reports (More than 2 pdf files)
then better use Temparary tables ..it will show u the
performance
| Is This Answer Correct ? | 1 Yes | 2 No |
where can we find the list of ps delivery tables?
Does Tuxedo use psappsrv.cfg in text form to determine run-time parameters for the domain? If not, what does it use?
What is the Difference between BI,CI,IB?
Tell me your experience with CI?
What is the order for installing the application, tools, and third party products?
What ID is used to establish the initial connection to the database?
What do you ‘run’ the Database Wizard?
what are the differences between development view and upgrade view?
What other files are copied to this directory? What is the purpose of each?
What is the difference between logging into Data Mover in bootstrap mode and logging-in in Regular Mode?
How to refresh PeopleSoft security from one Instance to another?
What are the PeopleSoft components for the Web Server?
PeopleSoft HRMS 
