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 a Listener process and a Handler process?

1267


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

1429


What is the Tux IPC Helper?

1473


What is nVision Tab? 

1253


What is the difference between logging into Data Mover in bootstrap mode and logging-in in Regular Mode?

1706


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

1386


What is the importance of the queue status? 

1481


What is an Application Server Domain?

1355


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

1380


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

1272


What do you ‘run’ the Database Wizard?

1262


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

1366


 What must be installed prior to running the PeopleSoft installer? 

1420


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

1275


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

1247