What is Performance tuning of SQR?




Answers were Sorted based on User's Feedback



What is Performance tuning of SQR?..

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

What is Performance tuning of SQR?..

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

What is Performance tuning of SQR?..

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



Post New Answer



More PeopleSoft AllOther Interview Questions

What is the difference between the 7.5X Vs 8X security?

0 Answers  


What is the Difference between BI,CI,IB?

1 Answers  


What is an Application Server Domain?

0 Answers  


what are the differences between development view and upgrade view?

3 Answers  


What is the order for installing the application, tools, and third party products?

0 Answers  






What is the Tux IPC Helper?

0 Answers  


What Web Service software is currently supported in PeopleSoft 8.4? 

0 Answers  


For each PeopleSoft application that is installed, the installer creates two databases. What are they? Explain?

0 Answers  


 What areas of your organization need to be involved in the install process?

0 Answers  


Does Tuxedo use psappsrv.cfg in text form  to determine run-time parameters for the domain? If not, what does it use? 

0 Answers  


What is Performance tuning of SQR?

3 Answers  


If the emphasis in PeopleSoft 8 is the internet, why do we still need windows client? 

0 Answers  






Categories
  • PeopleSoft HRMS Interview Questions PeopleSoft HRMS (83)
  • PeopleSoft Financials Interview Questions PeopleSoft Financials (27)
  • PeopleSoft Administration Interview Questions PeopleSoft Administration (181)
  • PeopleSoft Tools Interview Questions PeopleSoft Tools (176)
  • PeopleSoft Interfaces Interview Questions PeopleSoft Interfaces (58)
  • Internet EBusiness Interview Questions Internet EBusiness (19)
  • PeopleSoft Implementation Interview Questions PeopleSoft Implementation (142)
  • PeopleSoft General Interview Questions PeopleSoft General (385)
  • PeopleSoft AllOther Interview Questions PeopleSoft AllOther (60)