one particular query taking long time how to reduce that time

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the search keys you use to find patches and fixes?

673


What peopletools contains?

565


What elements are there in psadmin?

797


What is multi server definition in weblogic server?

656


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

628


Explain where are workflow work items found?

756


Tell me what views available in application designer project workspace?

659


How can you configure peoplecode trace?

682


Explain how many message nodes are possible for a database?

659


Explain application server clustering?

771


Differentiate between dddaudit and sysaudit?

730


Explain state records. What is its purpose?

673


How can you control weblogic server life cycle?

636


What does psadmin do?

629


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

577