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

What are the differences between RowClass and RowSet in PeopleSoft?

You want a single output by comining two or more queries. How would you do that?

What event gets fired after DB Update?

What are the ae program options?

What is added as new option in Build apart from Create Tables, Indexes, Views?

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

How to check processing consuming by peoplesoft

When a business requirement in Fit or Gap Analysis does not meet by PeopleSoft then what to do?

What is single server definition in weblogic server?

Is it ok to install two different peoplesoft versions on same machine?

If you want to log into DataMover in Bootstrap mode, How would you login?

What does psadmin do?

For more PeopleSoft Administration Interview Questions Click Here