Gabriel, I think it means that this count can be done from an index, so there's no need to access the actual table at all.
Andy > -----Original Message----- > From: Gabriel PREDA [mailto:[EMAIL PROTECTED] > Sent: 17 February 2005 11:16 > To: mysql@lists.mysql.com > Subject: EXPLAIN: Select tables optimized away > > MySQL 4.1.10 > > What does "Select tables optimized away" mean ? > > mysql> explain SELECT COUNT(*) AS total FROM members_twining_main; > | 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL > | > NULL | Select tables optimized away | > > > Gabriel PREDA > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
