What is Performance tuning of SQR?
- 3 Answers
- 8707 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 |
What are the three logical sets of tables that make up a PeopleSoft database and what is the purpose of each?
What are the client names when you execute a client status in psadmin?
What is included on the People Tools CD-ROMS?
What is nVision Tab?
How do you decide between appeng Ci and SQR while conversion?
When is the psappsrv.ubb file created and how is it used?
What is Web Server clustering?
What are the various documents you need to become familiar with prior to the installation?
When viewing server status, you see programs, group names, and ID numbers. How can you use these when administrating the domain?
i want to know the trainnig instittutie of people soft in pune?
Describe two SQR reports you can run to check the integrity of the database?
Does Tuxedo use psappsrv.cfg in text form to determine run-time parameters for the domain? If not, what does it use?
PeopleSoft HRMS 
