[thesite] faster queries on new w.e.o

Dean Mah dsmah at home.com
Tue May 22 18:06:03 CDT 2001


Daniel J. Cody writes:

> dean, those indexes made a huge difference!

It might not help in this case but you should put the driving table
last in the FROM clause of your query.  That is, the table that will
reduce the number of returned rows should be placed last in the FROM
clause.  Usually this is the table with the most WHERE conditions.

This might not help in this case.  The optimizer will usually re-order
the tables to take advantage of indexes, etc., but if tables come out
with the same weight, the last one listed will be used first.

Dean




More information about the thesite mailing list