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 bb and bbl.

In which platform does Crystal and Psnvision works?

What bea product is used for db transaction in peoplesoft? How would you log into the bs mode?

What is jvm heap?

How can you change the jvm heap size?

Where are workflow work items found?

Explain where are workflow work items found?

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

What are the analytic servers?

What statuses are available in peoplesoft domain status menu?

Which peopletools system table is used to track object changes?

What views available in Application Designer project workspace?

For more PeopleSoft Administration Interview Questions Click Here