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

Explain how to login into bs mode?

SYSAUDIT finds for?

Explain one to many relationship.

How do you uninstall the weblogic server?

What are the uses of psstatus table?

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

what happens when changing from NO EDIT TO EDIT option?

Which Web Services is only used as a Proxy Server?

Explain recycling the server processes.

What are Menu types available?

Explain session_timeout parameter?

Why do we use weblogic server in peoplesoft?

For more PeopleSoft Administration Interview Questions Click Here