The order of tables in the from does NOT make any difference. The
optimizer (normally) will rewrite the kwiri to suit its needs. Also
the order in the WHERE does not make any difference.
You should put all restrictions into the WHERE clause, which is MUCH
faster than putting them into the HAVING.
The order of the WHERE clause does make a difference.
The same is true of table joins. I don't think that
the order of tables in the FROM clause makes a
difference.
olinux
--- [EMAIL PROTECTED] wrote:
As we're on this topic in another thread right now:
Say I have a SELECT query from more