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

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

1211


What is included on the People Tools CD-ROMS? 

1017


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

1221


What are the three logical sets of tables that make up a PeopleSoft database and what is the purpose of each?

1103


What port does the Web Server use? 

1138


When viewing server status, you see programs, group names, and ID numbers.  How can you use these when administrating the domain?

1047


What is nVision Tab? 

992


What file created when you choose to create a domain in psadmin? From what order files is it created? Where is it located?

1021


What is IVT?

1894


What is Application Designer?

1061


Why use internet access as the client for PeopleSoft application? 

973


 What must be installed prior to running the PeopleSoft installer? 

1160


What is Spawn Threshold? 

1515


What dose the Database Wizard do?

1019


What is an Application Server Domain?

1117