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 Tux IPC Helper?

1468


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

1939


How to refresh PeopleSoft security from one Instance to another?

1317


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

1272


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

1698


What is nVision Tab? 

1248


What are the client names when you execute a client status in psadmin? 

1494


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

1299


What is IVT?

2145


Name the Tuxedo / Jolt Process and describe their functions? 

1235


What is Application Designer?

1303


What does port 3050 resolve to as hexadecimal?

1409


What do you ‘run’ the Database Wizard?

1258


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

1259


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

1346