SQL Optimisation , FROM Clause table order, Where clause etc

Hi All

I'm trying to find out if the order of the tables listed in the from clause will affect performance when querying from more than one table. Also should the Where clause start with expressions from larger tables etc.

EG TABLE A 10000 Rows TABLE B 5000 rows TABLE C 100 rows

SELECT A.COL1, B.COL etc etc
FROM A, B,C
WHERE A.COL1 = B.COL1 AND

                A.COL2 = B.COL2 AND
                B.COL4 = C.COL3

I want to know if
1. the FROM clause table order will affect performance and 2. the where clause works in a similar fashion Received on Tue Aug 04 1998 - 02:11:50 CDT