order of the join issue?

[Tamgo]

Hello everyone,
Please suggest if in the example given below, would the order of the joins make a difference on large tables?
i.e. If
SELECT T1.*, T2.*, T3.* FROM T1
LEFT JOIN T2 ON T1.id = T2.id
LEFT JOIN T3 ON T1.id = T3.id
WHERE ......

be any different than:
SELECT T1.*, T2.*, T3.* FROM T1
LEFT JOIN T3 ON T1.id = T3.id
LEFT JOIN T2 ON T1.id = T2.id
WHERE ......

Any feedback out there?
Thanks in advance -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[inder]

Yes, i think it makes a difference depending on the relative sizes of the tables without indexes or on the number of matching rows in each table with indexes. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --