one particular query taking long time how to reduce that time

Answer Posted / swap

Ask DBA for performance tuning of that Query

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where would you install connectivity software?

666


What is idda logging?

635


Explain the installation of peoplesoft.

674


How do we start & stop peoplesoft webserver in single server domain?

681


Differentiate between dddaudit and sysaudit?

726


How can you start weblogic on microsoft windows?

655


Given ma a sql statement, if you have been asked to check the right syntax?

623


How to login into bs mode?

640


What is a connectivity software?

708


What is peoplesoft configuration manager?

911


Explain state records. What is its purpose?

669


Can you give example scenario for analytic server?

637


Explain environment hub?

700


All the application servers in production environment have reached a threshold. How would you configure a new application server so that the web server is not bounced?

725


Which crystal report does peoplesoft query tool create by default?

661