Hi all, I was just fiddling around with some indexes on a table and decided to do an EXPLAIN for a query I was trying to optimize. I got a peculiar message output, and I'm not sure what it's trying to tell me! This is what I got: mysql> explain select min(impression), max(impression) from eventlog_81; +------------------------------+ | Comment | +------------------------------+ | Select tables optimized away | +------------------------------+ 1 row in set (0.00 sec) As you can see, it contains none of the usual information I was expecting. I tried looking up that message in the manual, but it isn't covered in the info on EXPLAIN. I reckon it might be saying that it figured out the answer to the query without having to look at the table (i.e. only consulting the index on the 'impression' column), but I'm not sure. Can anyone tell me what this message means? Regards, ------------------------------------------------ Basil Hussain ([EMAIL PROTECTED]) --------------------------------------------------------------------- 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
