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 |
Explain psstatus table. What is its use?
What event gets fired after DB Update?
After logging into customer connection, you wish to search for fixes or patches. What are the search criterias available ?
In which platform does Crystal and Psnvision works?
What is a connectivity software?
The Security Administrator is not available. You are in a hurry to grant a user the ability to start an application server, and you decide to make the change in the actual application server configuration file, rather than using the Security Administrator. Referring to the above information, how would you grant a user the ability to start an application server using the application server configuration file, PSAPPSRV.CFG?
Suppose you have created a menu and a page and given user access to that page, which of the tables gets affected on this?
What is peoplesoft server process logs?
what happens when changing from NO EDIT TO EDIT option?
How to get a single ouptut by combining two or more queries?
Explain the architecture of peoplesoft.
What are the valid values in peoplecode debugger?