Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 difference between logging into Data Mover in bootstrap mode and logging-in in Regular Mode?

1650


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

1187


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

1224


What Web Service software is currently supported in PeopleSoft 8.4? 

1329


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

1198


What do you ‘run’ the Database Wizard?

1209


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

1429


What is the difference between a Listener process and a Handler process?

1217


You Migrate some page changes from development to test environment but still the user complaints the changes are still not reflected in the test environment.  What could be the problem and how will you resolve it?

1276


Describe two SQR reports you can run to check the integrity of the database? 

1245


What is PeopleSoft Internet E-Business?

764


You want to change a Application Server name and the WebServer which file will you     modify and where?

1174


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

1425


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

1299


What other files are copied to this directory? What is the purpose of each?

1347