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


Please Help Members By Posting Answers For Below Questions

What are the valid values in peoplecode debugger?

504


How can you configure peoplecode trace?

518


What are menu types available in peoplesoft?

522


Explain recycling the server processes.

578


Explain load balancing?

462






What is peoplesoft server process logs?

498


Explain the installation of peoplesoft.

518


If you want to use a new image in hrms, where would it be stored?

514


You want to change the system passowrd. How would you do it?

457


Given ma a sql statement, if you have been asked to check the right syntax?

472


What is idda logging?

491


Why do we use weblogic server in peoplesoft?

528


Is it ok to install two different peoplesoft versions on same machine? If yes, how would you do it?

499


Peoplesoft supports which web servers?

528


Explain bb and bbl.

634