Does order in from and where clause matter?

From: Frank Calfo <fcalfo_at_psateam.com>
Date: 10 Jun 1999 15:29:05 GMT
Message-ID: <01beb356$9dd390c0$e401010a@FRANK>

If a query is selecting from multiple, joined tables does the order of the tables in the from clause effect the efficiency of the query?

For example (excluding the where clause):

    Does "select emp.name,

                       group.name
                 from emp,
                        group "
    execute any different than


            "select emp.name,


                       group.name
                from group,
                       emp"

Does the order of the tables in the where clause effect the efficiency of the query?

    Does "select emp.name,

                       group.name,
                       type.desc
                 from emp,
                        group,
                        type 
                where emp.empid = group.empid and
                          emp.typeid = type.typeid"
    execute any different than


            "select emp.name,


                       group.name,
                       type.desc
                 from emp,
                        group,
                        type 
                where emp.typeid = type.typeid and
                          emp.empid = group.empid"

Does it matter which side of the equal sign in the where clase that the tables are listed?

For example: does "emp.empid = group.empid"

                        execute any differently than "group.empid =

emp.empid"

Thanks. Received on Thu Jun 10 1999 - 10:29:05 CDT