Eric,
Can you send us the actual show indexes from table and explain output that
isn't shortend?
Thank you for answer my question.
Actually, the real query and tables are much more complex than
the data in the previous message.
A just tryed to optimize the information for you better understand the
trouble.
I think found what´s happening.
A SELECT WHERE city = 1 returns more rows thant a full table scan
in the table "front" (the real states that appear in the front page).
So, it seems MySQL choose the second option, once it has less rows
to optimize.
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
