First I want to thank Robert, Steve and the group for helping me get it.
Does the order of the clauses of the AND operator make a difference in
performance? It should be I think.
SELECT * FROM Products, Join, Types WHERE Products.prodID = Join.prodID AND
Join.typeID = Types.typeID AND Types.typeName LIKE 'AMD';
for the following 3 simple many-to-many tables.
Should I arrange the postion of the clause of the AND operator to optimize
the query??? Should I have
..... WHERE Types.typeName LIKE 'AMD' AND Types.typeID = Join.typeID AND
Join.prodID = Products.prodID; (I think this is the fastest)
.....WHERE Types.typeName LIKE 'AMD' AND Join.prodID = Products.prodID AND
Types.typeID = Join.typeID ;
(Is there any difference?)
.....WHERE Join.prodID = Products.prodID AND Types.typeID = Join.typeID AND
Types.typeName LIKE 'AMD';
I can manipulate it by many ways, but the short question is "will it be
DIFFERENT?" The Join table has a few times more records but way smaller in
size than the Products table.
Really appreciate it.
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com