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 what are the search keys you use to find patches and fixes?

What are the various layers of peoplesoft. Explain them.

Which peopletools system table is used to track object changes?

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

Given ma a sql statement, if you have been asked to check the right syntax?

What peopletools contains?

one particular query taking long time how to reduce that time

Suppose I have created a menu and a page and given user access to that page, which of the tables gets affected on this?

How can you control weblogic server life cycle?

What is idda logging?

Name a few third party tools / software required for ps to function.

PS Query definition is stored on which server?

For more PeopleSoft Administration Interview Questions Click Here