I believe MySQL doesn't do a lot of the optimizations that MSSQL does.
However, you can do it manually (I think) by playing around with both
the order of the where clause and the order of the join clause
The where clauses go in order, so you want to use the first part of the
where clause to get
Adam,
[ mysql, query ]
However, you can do it manually (I think) by playing around with both
the order of the where clause and the order of the join clause
Yes.
Also, MySQL has a really wimpy default configuration (I can't figure out
why). Here is my /etc/my.cnf (I don't know what the