Hi, I recently upgraded from 4.0.4 to 4.0.7 . I keep getting the following error message when a executing a query:
ERROR 1104 at line xx : The SELECT would examine too many records and probably take a long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok. The problem is that this query used to work perfectly with previous versions of Mysql and that using SET OPTINION SQL_BIG_SELECTS=1 doesn't help : Does anyone have a clue ? Best Regards Andrea Forghieri Emmegi S.p.A. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php