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

Explain psstatus table. What is its use?

0 Answers  


What event gets fired after DB Update?

1 Answers  


After logging into customer connection, you wish to search for fixes or patches. What are the search criterias available ?

2 Answers  


In which platform does Crystal and Psnvision works?

7 Answers  


What is a connectivity software?

0 Answers  


The Security Administrator is not available. You are in a hurry to grant a user the ability to start an application server, and you decide to make the change in the actual application server configuration file, rather than using the Security Administrator. Referring to the above information, how would you grant a user the ability to start an application server using the application server configuration file, PSAPPSRV.CFG?

1 Answers  


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

0 Answers  


What is peoplesoft server process logs?

0 Answers  


what happens when changing from NO EDIT TO EDIT option?

2 Answers  


How to get a single ouptut by combining two or more queries?

0 Answers  


Explain the architecture of peoplesoft.

0 Answers  


What are the valid values in peoplecode debugger?

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)