What is Performance tuning of SQR?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When is the psappsrv.ubb file created and how is it used? 

1179


Is JOLT an acronym? 

1041


What are the different types of databases, why do they differ, and what is the purpose of each?

1382


What is an Application Server Domain?

1077


What are the client names when you execute a client status in psadmin? 

1180


How to refresh PeopleSoft security from one Instance to another?

983


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

954


Where is the setup.exe to install the PeopleSoft components to the Web Server?

1196


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

1104


Briefly describe PeopleSoft and Non PeopleSoft objects?

1083


Have you done Migration? How to build in PeopleSoft ? Why build from Oracle?

1072


How do you regenerate PSTUXCFG after manually changing psappsrv.cfg? 

1669


What are the PeopleSoft components for the Web Server? 

1180


What is nVision Tab? 

981


How will you enable SMTP on Application Server?

1015