Slow Performance in Production Database

What is the solution if some users are encountering slow performance in production db?

Showing Answers 1 - 4 of 4 Answers


  • Dec 4th, 2016

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

  1. SELECT department_id, last_name, salary

  2. FROM   employees

  3. WHERE  salary > 5000

  4. ORDER BY department_id, last_name;


  6. This IS an example OF full INDEX scan

  Was this answer useful?  Yes


  • 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