SQL Tuning Question

I like to know whether the order of the joins in SQL statement make any difference in the performance.
For example,

    select * from emp, dept

     where emp.deptno = 20 and
                 emp.deptno = dept.deptno;

any different from using "select... dept.deptno = emp.deptno"

If you have any sql tuning tips, please email to me too! Received on Wed Mar 17 1999 - 09:46:01 CET