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

Given a SQL Statement, if you have been asked to check the right syntax ?

what are the views available in App. Designer project workspace?

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

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

Customization done in Dev DB, Which tool you will use to move it to Prod DB?

Update and Fixes: R-* files refers to what?

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

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

What hyperlinks available in PeopleBooks?

Which commands can be run in Bootstrap mode?

What are the Search Keys you use to find Patches and Fixes?

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

For more PeopleSoft Administration Interview Questions Click Here