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 is the importance of the queue status? 

1239


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

1102


What is the Tux IPC Helper?

1225


What is IVT?

1900


What is Spawn Threshold? 

1525


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

1411


What is Tnsnames.ora? 

1300


What is an Application Server Domain?

1135


What do you ‘run’ the Database Wizard?

1023


What are the PeopleSoft components for the Web Server? 

1211


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

1179


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

1220


You configure and boot the domain from the command line.  Why did more processes than expected start when the domain was booted? 

1244


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

1148


What is included on the People Tools CD-ROMS? 

1026