one particular query taking long time how to reduce that time
Answer Posted / ashok
Check the index and execution plan was recently changed or not.If its not changed let tune the query
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
You want a single output by comining two or more queries. How would you do that?
You want to change the system passowrd. How would you do it?
How would you connect as a tier in application designer?
Name a few third party tools / software required for ps to function.
You want to upgrade a peoplesoft tool. How would you do it?
What are peopletools utilities and what it contains?
Suppose I have created a menu and a page and given user access to that page, which of the tables gets affected on this?
Explain the menu types available in peoplesoft?
What bea product is used for db transaction in peoplesoft? How would you log into the bs mode?
Can you give an example of peoplesoft server process logs?
Explain one to many relationship.
How to get a single ouptut by combining two or more queries?
All the application servers in production environment have reached a threshold. How would you configure a new application server so that the web server is not bounced?
What elements are there in psadmin?
Explain environment hub?