What is the performance tuning of sqr?
- 1 Answers
- 866 Views
- I also Faced
- E-Mail Answers
Answer / Alok Kumar Agmani
SQR performance can be optimized by reducing the amount of data read and written, indexing tables, minimizing subqueries, avoiding unnecessary calculations, using stored procedures where possible, and using appropriate sort and join methods.
| Is This Answer Correct ? | 0 Yes | 0 No |
Please differentiate between translate, processing, control and transaction tables?
What is difference between trlate table and prompt table?
Explain about hrms foundation tables sequencing?
What actions will occur, when a Component Interface (CI) is created on component that has Add action enabled?
Which of the above record definitions is not stored on the database and therefore not required to build?
Suppose you need not create separate db for every user in ppsft 8.4 onwards. This is possible because of?
Do you know what are the triggers in a component?
How do you retrieve a value from scroll.scroll select?
Some pc file attachment functions?
What is the difference between err msgget and war msgget?
Explain how to define the names of the application servers being used to access peoplesoft?
How to views two program of ae program?
PeopleSoft HRMS 
