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

Explain the architecture of peoplesoft.

567


What are peopletools utilities and what it contains?

474


What are peopletools utilities?

512


How can you configure peoplecode trace?

518


How to get a single ouptut by combining two or more queries?

438






What are menu types available in peoplesoft?

522


Can we install two different peopletools version on same machine ie client, if yes , what oracle configuration should be installed?

550


What is jvm heap?

586


What is the use of peoplesoft configuration manager?

495


Explain load balancing?

464


What are the various layers of peoplesoft.

515


You just started a new application server. What problems you may encounter?

494


I want to update my password and enter a hint for forgotten password. What would I access?

443


Explain compare reports?

521


Explain ren server?

535