Does Oracle uses Bottom Up approach while executing the Query? If So, should we be passing the input values at the end of the query?
SELECT d.dept_name
FROM employees e, dept d
where e.dept_id = d.dept_id
and e.emp_id = 123
Is this better than the below query?
SELECT d.dept_name
FROM employees e, dept d
where e.emp_id = 123
and e.dept_id = d.dept_id
If there is any documentation on this will be more helpful.