| How to improve performance [message #534511] |
Wed, 07 December 2011 00:25  |
 |
ravi_n
Messages: 5
Registered: November 2011
|
Junior Member |
|
|
Hi Experts,
SELECT emp_id,department.dept_code,dept_name,
FROM Employee,department
WHERE employee.dept_code=department.dept_code
AND salary>2000;
In employee table total 15000 records are there.
In department table total 500 records are there.
If I run this query it's taking 7 mins to execute.
Could you please help me to how to write
this join condition to improve performance.
Please provide the guidelines for how to write join conditions effectively.
Thanks in advance.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
