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 an Application Server Domain?

1281


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

1133


Name the Tuxedo / Jolt Process and describe their functions? 

1150


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

1189


What does port 3050 resolve to as hexadecimal?

1326


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

1369


What is Spawn Threshold? 

1655


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

1131


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

1138


What is IVT?

2050


Is JOLT an acronym? 

1223


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

1144


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

1128


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?

1233


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

1393