Sometimes it is faster to break an SQL statement into multiple queries or in VFP use FORCE so that the tables will be joined in the order you specify and not what the VFP optimizer thinks -- Arnon Gal - Oz
When using JOINS, the right table should be on the left of the ON comparison operator. I.E.
Select CUSTOMER.custid, ADDRESS.addressid from CUSTOMER ;
left outer join ADDRESS on ADDRESS.addressid == CUSTOMER.addressid
This is FAR faster!
I don't believe that's always true. In a join, the query engine figures out which index to use, and it is capable of using the tag from either table. SYS(3054) does tell you which one it uses. Do you have tests that prove your statement is generally true? -- Tamar Granor