I have a query like this :

select * from emp_salary a, department b
where location = 3
and b.deptid= 10
and a.deptid = b.deptid;

Which condition gets executed first? the one with location =3 or a.deptid=b.deptid or b.deptid=10 ???