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 are the PeopleSoft components for the Web Server? 

1365


Tell me your experience with CI?

2271


You’ve manually edited the psappsrv.cfg file.  Will the domain recognize the changes?

1272


What ID is used to establish the initial connection to the database?

1270


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

1117


What is nVision Tab? 

1135


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

1246


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

1833


Why use internet access as the client for PeopleSoft application? 

1107


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?

1222


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

1167


What port does the Web Server use? 

1291


How is PeopleSoft able to provide a database for customers on so many different database platforms?

1117


How to refresh PeopleSoft security from one Instance to another?

1210


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

1284