Thank you very much. That's what fixed my problem.
Robert J Taylor wrote:
Can you restrict to Not Null instead of != ""? (I.e, can you scrub the data not to have empty strings?).
The explain shows 3 extra where calculations per row...that's painful.
Great! Glad that solved your problem.
Robert Taylor [EMAIL PROTECTED]
P.S. I didn't respond to the list initially, so I'm correcting that now.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]