Join or Subquery?
I'would like to know if is better a normal join between 2 tables or a subquery?
Example:
---SUBQUERY
SELECT big_emp.column
FROM big_emp
WHERE dep_no IN (
SELECT dep_no
FROM big_dept);
---NORMAL JOIN
SELECT big_emp.column
FROM big_emp,big_dept
WHERE big_emp.dep_no = big_dept.dep_no
Which the optimize prefers?...and why?
Bye and thanks a lot, Andrea75 (from Italy)