one particular query taking long time how to reduce that time
Answers were Sorted based on User's Feedback
Answer / 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 |
what is sys audit?
What are the differences between RowClass and RowSet in PeopleSoft?
I have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?
What commands are valid in BS mode?
Which command is valid in both bootstrap and regular mode when operating the data mover?
What is peoplesoft configuration manager?
You want to update your password and enter a hint for forgotten password. What would you access?
Explain change assistant?
Suppose if you want to log into datamover in bootstrap mode, you would login as?
what happens when changing from NO EDIT TO EDIT option?
what could be the reason when CPU utilization is high when no load on app server? a. unidentified memory leakage in the server b. more psappsrv processes in the app server c. File system is full d. all of the above
Explain what are the differences between rowclass and rowset in peoplesoft?