one particular query taking long time how to reduce that time

Question Posted / venkat_timma

Answers were Sorted based on User's Feedback

one particular query taking long time how to reduce that time ..

Answer / swap

Ask DBA for performance tuning of that Query

Is This Answer Correct ?

3 Yes

3 No

one particular query taking long time how to reduce that time ..

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

More PeopleSoft Administration Interview Questions

What are the uses of psstatus table?

Where would you install connectivity software?

Explain state records. What is its purpose?

Tell us about web servers.

PS Query definition is stored on which server?

Explain what are the components which form the part of integration broker?

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

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

What are the status available in PeopleSoft Domain Status Menu?

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

Explain change assistant?

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

For more PeopleSoft Administration Interview Questions Click Here