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

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

Tell us about web servers.

what happens when changing from NO EDIT TO EDIT option?

Explain recycling the server processes.

What does psadmin do?

Which commands can be run in Bootstrap mode?

Explain where are workflow work items found?

Explain the architecture of peoplesoft.

What views available in Application Designer project workspace?

Which tree types is NOT supported in the PeopleSoft tree manager?

Differentiate between dddaudit and sysaudit?

Explain about the Optimizer values passed in Oracle?

For more PeopleSoft Administration Interview Questions Click Here