Slow Performance in Production Database

What is the solution if some users are encountering slow performance in production db?
  • Interview Candidate
  • 6
  • 5737

Showing Answers 1 - 6 of 6 Answers

Shalu

  • Dec 4th, 2016
 

Check the query that is running in database, try to optimize the query by using correct hint and indexes

Code
  1. SELECT department_id, last_name, salary 

    2. 

  2. FROM   employees

    3. 

  3. WHERE  salary > 5000 

    4. 

  4. ORDER BY department_id, last_name;

    5. 

  5.  

    6. 

  6. This IS an example OF full INDEX scan

  Was this answer useful?  Yes

Abbey

  • Feb 16th, 2018
 

Scan for virus first

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions