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

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

1899


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

1378


What are the various documents you need to become familiar with prior to the installation?

1222


What is Tnsnames.ora? 

1490


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

1354


What Web Service software is currently supported in PeopleSoft 8.4? 

1339


What is the Tux IPC Helper?

1432


What port does the Web Server use? 

1344


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

1286


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

1253


 What must be installed prior to running the PeopleSoft installer? 

1379


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

1225


What is an Application Server Domain?

1319


Briefly describe PeopleSoft and Non PeopleSoft objects?

1343


What are the PeopleSoft components for the Web Server? 

1425