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

Where do we need to install connectivity software?

Where would you install connectivity software?

How many Message nodes are possible for a database?

you have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?

Is it ok to install two different peoplesoft versions on same machine? If yes, how would you do it?

A Customer wants to use a new Image in HRMS, where it is stored?

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

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

How do you set up table-sharing in PeopleTools applications?

Explain load balancing?

what is sys audit?

How do you login into BS mode?

For more PeopleSoft Administration Interview Questions Click Here