Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


one particular query taking long time how to reduce that time

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

Post New Answer

More PeopleSoft Administration Interview Questions

what is sys audit?

1 Answers  


What are the differences between RowClass and RowSet in PeopleSoft?

1 Answers  


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

1 Answers  


What commands are valid in BS mode?

2 Answers   Patni,


Which command is valid in both bootstrap and regular mode when operating the data mover?

2 Answers  


What is peoplesoft configuration manager?

0 Answers  


You want to update your password and enter a hint for forgotten password. What would you access?

2 Answers  


Explain change assistant?

0 Answers  


Suppose if you want to log into datamover in bootstrap mode, you would login as?

0 Answers  


what happens when changing from NO EDIT TO EDIT option?

2 Answers  


what could be the reason when CPU utilization is high when no load on app server? a. unidentified memory leakage in the server b. more psappsrv processes in the app server c. File system is full d. all of the above

2 Answers  


Explain what are the differences between rowclass and rowset in peoplesoft?

0 Answers  


Categories
  • PeopleSoft HRMS Interview Questions PeopleSoft HRMS (83)
  • PeopleSoft Financials Interview Questions PeopleSoft Financials (27)
  • PeopleSoft Administration Interview Questions PeopleSoft Administration (181)
  • PeopleSoft Tools Interview Questions PeopleSoft Tools (176)
  • PeopleSoft Interfaces Interview Questions PeopleSoft Interfaces (58)
  • Internet EBusiness Interview Questions Internet EBusiness (19)
  • PeopleSoft Implementation Interview Questions PeopleSoft Implementation (142)
  • PeopleSoft General Interview Questions PeopleSoft General (385)
  • PeopleSoft AllOther Interview Questions PeopleSoft AllOther (60)