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 |
Update and Fixes: R-* files refers to what?
Which command is valid in both bootstrap and regular mode when operating the data mover?
What BEA product is used for DB transaction in PS?
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?
What are various ways to trace a process / application in peoplesoft?
Which process is used for running AE programs which are to be run at a frequency of less than a day ?
How do you start weblogic on unix?
What is multi server definition in weblogic server?
Why do we use weblogic server in peoplesoft?
You want to authenticate a user in peoplesoft. How would you do that?
I want to update my password and enter a hint for forgotten password. What would I access?
What is idda logging?