"O'K Web Design" <[EMAIL PROTECTED]>
Subject: Re: EXPLAIN: Select tables optimized away
> 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 inde
ent: 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
ect: 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
>
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 li