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

How do you find app server / process scheduler are up and running ?

What is weblogic server administration console?

What does psadmin do?

What are the analytic servers?

You can specifically trace the activity of the PSAPPSRV server process by setting which one?

Tell us about web servers.

What is psadmin in peoplesoft?

Which command is valid in both bootstrap and regular mode when operating the data mover?

Explain bb and bbl.

Explain session_timeout parameter?

What are the ae program options?

Name the people tools available for integration broker?

For more PeopleSoft Administration Interview Questions Click Here