Check the index and execution plan was recently changed or not.If its not c

one particular query taking long time how to reduce that time

Question Posted / ashok

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

Please Help Members By Posting Answers For Below Questions

Explain application server clustering?

979

What are the peoplesoft configuration parameters?

847

Explain integration broker and its components.

842

Explain state records. What is its purpose?

849

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

830

What elements are there in psadmin?

990

Explain the menu types available in peoplesoft?

789

Explain load balancing?

751

What bea product is used for db transaction in peoplesoft? How would you log into the bs mode?

938

How do you uninstall the weblogic server?

915

Suppose if you want to log into datamover in bootstrap mode, you would login as?

836

Explain where are workflow work items found?

912

How can you launch configuration manager?

867

What are the valid values in peoplecode debugger?

928

We can specifically trace the activity of the psappsrv server process by setting which one?

762