I'm working on a routine and was optimizing queries for it when I ran across something I have never seen EXPLAIN return before. Can somebody tell me what it means when EXPLAIN returns: "Select tables optimized away"
If it helps, here is the simple query I was testing. EXPLAIN SELECT COUNT(updated = 0) FROM tbl_produpdate I couldn't find anything like this in my MySQL book or in the on line help. Thanks, Cary --------------------------------------------------------------------- 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
