O I see... I read this in MySQL Manual... I believe it's something like
SHOW TABLE STATUS LIKE 'table_name'
And then extract the number of rows... I never saw "Select tables optimized
away" and it confused me !
Gabriel PREDA
----- Original Message -----
From: "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 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]
