Hi
Counts are extremely fast and since you have no WHERE statement, it
takes the count value straight from the internals and does not look at the
tables or an index if I remember correctly. Mike
----- Original Message -----
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: February 17, 2005 6:15 AM
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]
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2005-02-14
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
