Slow Performance in Production Database

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

Showing Answers 1 - 2 of 2 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. FROM   employees

  3. WHERE  salary > 5000

  4. ORDER BY department_id, last_name;

  5.  

  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